Re: some questions

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: Ang Tun Chek <atchek(at)eware(dot)com(dot)my>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: some questions
Date: 2002-05-15 09:23:21
Message-ID: B907E799.3210%a.witney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


From within psql

> what is the sql command in postresql equal to "describe table"?

\d "tablename"

> what is the sql command to list all tables in the database?

\dt

More info and other commands can be found by typing \?

adam

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Marc SCHAEFER 2002-05-15 10:00:17 Re: Various PostgreSQL questions
Previous Message Christopher Kings-Lynne 2002-05-15 09:22:23 Re: some questions