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
~~~~~~~~~~~~~~
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 |