Re: Looking for a command to list schemas - Mailing list pgsql-general

Le 2005 10 26 09:36, Martijn van Oosterhout a ecrit:
> On Tue, Oct 25, 2005 at 11:25:22AM -0700, Cosmopo wrote:
> > Hello,
> >
> > We are presently experimenting with Postgresql schemas... We used basic
> > commands like \d  to list info from all tables/sequence/owner in a
> > db... The schema info was always "public" since we never created one...
>
> \dn   list schemas
> \dt *.*  list all tables in all schemas
> \z *.*   list priveledges for all tables in all schemas
> etc...
>
> Is this helpful?

Hello,

Yes and no... The \dn  does not list the schemas... I thinks it's my old
Postgresql version (7.3.2 and 7.3.4)...  But  \z  does the trick...

It's a sign that it's time to upgrade...  8-)
Thanks
--
Mark
~~~~~~~~~~~~~~