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
