On Thu, Feb 22, 2024 at 10:32 AM Erik Wienhold <ewie@ewie.name> wrote:
On 2024-02-22 09:32 +0100, Fabrice Chapuis wrote: > I want to persist a shortcut between session. > > > > postgres [157394]=# \set cs 'select current_schema'; > > postgres [157394]=# :cs > > ┌────────────────┐ > > │ current_schema │ > > ├────────────────┤ > > │ public │ > > └────────────────┘ > > (1 row) > > > I put it in .pgsql_profile but it does not work > > any idea?
What output do you get?
You should put that \set or \ir .pgsql_profile in .psqlrc which is the standard file read by psql.