Re: Looking for a command to list schemas

From: Marc Andre Paquin <tempo(at)marquo(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Looking for a command to list schemas
Date: 2005-10-27 19:33:34
Message-ID: 200510271533.34968.tempo@marquo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
~~~~~~~~~~~~~~

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-27 19:46:08 Re: aix build question re: duplicate symbol warning
Previous Message Kevin Murphy 2005-10-27 18:23:36 aix build question re: duplicate symbol warning