Is there a PostgresQL equivalent to the DESCRIBE keyword???

From: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there a PostgresQL equivalent to the DESCRIBE keyword???
Date: 2001-12-14 21:43:26
Message-ID: JBEOIGCPFENBBBIKPPLCEEBACAAA.pchen3@jhmi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey All,

I'm trying to display the schema to various tables. In most other
databases, you can use the DESCRIBE keyword or the SHOW keyword (I believe
this is a SQL99 keyword). Is there an equivalent in PostgresQL?

Also, does PostgresQL have an equivalent to the following:

SHOW CREATE TABLE table_name

Thanks for any help.

Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Finner 2001-12-14 21:50:47 Re: Perl DBI, PostgreSQL performance question
Previous Message omid omoomi 2001-12-14 21:20:42 Re: slow queries on large syslog table