Re: SHOW - Mailing list pgsql-general

From bpalmer
Subject Re: SHOW
Date
Msg-id Pine.BSO.4.33.0109031512210.27936-100000@mizer.crimelabs.net
Whole thread Raw
In response to SHOW  (Stephan Bergmann <sb@ows.es>)
List pgsql-general
> What is the equivalent to the mysql's:
> SHOW COLUMNS FROM [TABLENAME];

in psql,  \d will show you all tables and \d TABLE will show you the
columns in the table.  If you need it as a sql command,  you can check the
system tables.

- Brandon

----------------------------------------------------------------------------
 b. palmer,  bpalmer@crimelabs.net            pgp:crimelabs.net/bpalmer.pgp5


pgsql-general by date:

Previous
From: "Joe Conway"
Date:
Subject: Re: Adding a Foreign Key
Next
From: Tom Lane
Date:
Subject: Re: Question about plan