Re: \set to create shortcut

Ok I put it .psqlrc file. It works. Thanks to you
Fabrice

On Thu, Feb 22, 2024 at 10:32 AM Erik Wienhold <ewie(at)ewie(dot)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.
>
> --
> Erik
>