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.
--
Erik