On Thu, 2024-02-22 at 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?
It works for me if I put the semicolon inside the single quotes.
Yours,
Laurenz Albe