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

while in psql type:

\d tablename

(don't add a semicolon)

On Fri, 14 Dec 2001, Peter E. Chen wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>