Re: [GENERAL] A simple SQL command

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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden