Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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            Sweden

In response to

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group