Re: [GENERAL] A simple SQL command

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: Edouard DESSIOUX <edx(at)intrinsec(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] A simple SQL command
Date: 1999-10-28 10:21:10
Message-ID: Pine.GSO.4.02A.9910281219210.567-100000@Puma.DoCS.UU.SE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yury Don 1999-10-28 11:31:03 Re: [GENERAL] A simple SQL command
Previous Message ednut 1999-10-28 09:20:57 Re: Linux/Postgres 6.5 problems using jdbc w/jdk1.2