Re: Looking for a command to list schemas

Поиск
Список
Период
Сортировка
От Marc Andre Paquin
Тема Re: Looking for a command to list schemas
Дата
Msg-id 200510271533.34968.tempo@marquo.com
обсуждение исходный текст
Ответ на Re: Looking for a command to list schemas  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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
~~~~~~~~~~~~~~

В списке pgsql-general по дате отправления:

Предыдущее
От: CG
Дата:
Сообщение: Function written in C, hangs on one machine and not another...
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Function written in C, hangs on one machine and not another...