Re: Speed Question

Philip Hallstrom <philip@adhesivemedia.com>

From: Philip Hallstrom <philip@adhesivemedia.com>
To: Noah Silverman <noah@allresearch.com>
Cc: pgsql-performance@postgresql.org
Date: 2002-12-21T01:01:13Z
Lists: pgsql-performance
> BTW - is there any kind of "describe table" and/or "show index"
> function if pgsql.  I've gotten very used to them in Mysql, but they
> don't work here.  There must be some way.  I've RTFM, but can't find
> anything.  help.

In psql use "\d tablename".  do a "\?" for a quick overview and "man psql"
for lots of stuff.

-philip