Re: get table schema in psql?

From: "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net>
To: pgsql-sql(at)hub(dot)org
Subject: Re: get table schema in psql?
Date: 2000-09-15 23:53:39
Message-ID: Pine.LNX.4.10.10009151651290.4007-100000@altoplanos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 15 Sep 2000, Rommel B. Abaya wrote:

> type \d [tablename] at the psql console

And if you like that try:

\d+ [tablename]

Of course it's much more impressive if you've created any COMMENTs.

Rod
--
Roderick A. Anderson
raanders(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Keith Wong 2000-09-16 04:00:03 installing pgaccess
Previous Message Jie Liang 2000-09-15 21:36:38 Re: Error with DISTINCT