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
In response to
pgsql-general by date
|Next:||From: Yury Don||Date: 1999-10-28 11:31:03|
|Subject: Re: [GENERAL] A simple SQL command|
|Previous:||From: ednut||Date: 1999-10-28 09:20:57|
|Subject: Re: Linux/Postgres 6.5 problems using jdbc w/jdk1.2|