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
>