Re: SHOW

From: bpalmer <bpalmer(at)crimelabs(dot)net>
To: Stephan Bergmann <sb(at)ows(dot)es>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SHOW
Date: 2001-09-03 19:13:25
Message-ID: Pine.BSO.4.33.0109031512210.27936-100000@mizer.crimelabs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crimelabs(dot)net pgp:crimelabs.net/bpalmer.pgp5

In response to

  • SHOW at 2001-09-03 17:37:30 from Stephan Bergmann

Responses

  • Re: SHOW at 2001-09-04 06:32:34 from Stephan Bergmann

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-09-03 19:16:31 Re: nested SQL with SPI
Previous Message Tom Lane 2001-09-03 19:07:38 Re: ERROR: Function 'format_type(oid, int4)' does not exist