Re: Migrating from mysql.

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