Re: list schema - Mailing list pgsql-admin

From Jean-Luc Lachance
Subject Re: list schema
Date
Msg-id 3DEFD0E5.98F13585@nsd.ca
Whole thread Raw
In response to Re: list schema  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
How about \D for Domains...

BTW, because many people ask how to do the equivalant in SQL of a \
command,
why not be done with the \ commands which are criptic anyway and instead
create global stored procedures like:

sp_list_databases()
sp_list_schemas()
sp_list_{whatever}()
sp_enable_{this}()
sp_disable_{that}()

JLL


Tom Lane wrote:
>
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Also, on TODO I see:
> >       * Add schema, cast, and conversion backslash commands to psql
> > so we know we need them.
>
> I was going to add one for schemas, but \ds and \dS are already taken,
> and there was no good proposal for what to use instead.  Any thoughts?
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-admin by date:

Previous
From: "Robert M. Meyer"
Date:
Subject: Postgres 7.3 and phpPgAdmin
Next
From: Jie Liang
Date:
Subject: Re: list schema