On Thu, May 25, 2000 at 04:58:48AM +1000, Giles Lean wrote:
>
> On Mon, 15 May 2000 23:04:48 +0100 Joe Karthauser wrote:
>
> > And last but not least I'm used to using the 'desc tablename' sql command
> > to show the structure of a table within MySQL. How do I do the same in
> > PostgreSQL.
>
> In psql "\i tablename". Check out \? or the documentation for all the
> different backslash commands. You might want \z for access
> permissions as well.
Actually, it's "\d tablename". The rest is right, though.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005