From: | "omid omoomi" <oomoomi(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] A simple SQL command |
Date: | 1999-10-28 04:08:39 |
Message-ID: | 19991028110840.57549.qmail@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,you may also use :
select * from pg_tables where owner='somebody' ;
and for the table structures you can join some system tables(pg_attribute ,
pg_class ,pg_type),but \d table_name is a better way.
regards,
omid omoomi.
>From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
>Reply-To: Peter Eisentraut <peter_e(at)gmx(dot)net>
>To: Edouard DESSIOUX <edx(at)intrinsec(dot)com>
>CC: pgsql-general(at)postgreSQL(dot)org
>Subject: Re: [GENERAL] A simple SQL command
>Date: Thu, 28 Oct 1999 12:21:10 +0200 (MET DST)
>
>On Wed, 27 Oct 1999, Edouard DESSIOUX wrote:
>
> > How could i know the name of all the table in my database
> > and, if possible, their prototype.
> > I would like a SQL command if possible
>
>From within psql, enter \dt.
>It's not an SQL command though.
>
>To look at the "prototype", as you say, enter \d tablename.
>
>--
>Peter Eisentraut Sernanders vaeg 10:115
>peter_e(at)gmx(dot)net 75262 Uppsala
>http://yi.org/peter-e/ Sweden
>
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-10-28 04:34:39 | Re: [GENERAL] Admin details - disk space used |
Previous Message | Simon Drabble | 1999-10-28 03:29:06 | Admin details - disk space used |