Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!

From: Roland Roberts <roland(at)astrofoto(dot)org>
To: "Ron de Jong" <Ron(dot)Antispam(at)news(dot)tht(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!
Date: 2001-10-23 20:22:13
Message-ID: m2k7xm9kei.fsf@tycho.rlent.pnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>>>> "Ron" == Ron de Jong <radejong(at)planet(dot)nl> writes:

Ron> Any idea to get a human readable list with column
Ron> descriptions like type,size,key,default,null.

Ron> It would be nice if it would look simular to the mysql
Ron> variant:

You'll need to write your own query to get it to look like mysql.
>From psql, you can do

\d employee

roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-10-23 20:41:54 Re: [GENERAL] To Postgres Devs : Wouldn't changing the
Previous Message Tom Lane 2001-10-23 19:31:27 Re: PL/pgSQL RENAME bug?