| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Guillaume Houssay" <ghoussay(at)noos(dot)fr>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL question |
| Date: | 2003-06-10 07:04:10 |
| Message-ID: | 200306100804.10644.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Monday 09 Jun 2003 2:30 pm, Guillaume Houssay wrote:
> I found a way to have the list of all the tables for my database.
>
> Now, I would like to get the name of the columns of any table.
> I could not find the SQL command to do that.
>
> Thank you for you help
In psql there are a number of backslash commands - you might find the
following useful:
\d
\dt
\dv
\d mytable1
\d my*
If you start psql with the -E flag you'll see the SQL that's used to run
these. See "man psql" or the manuals for more info.
--
Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-06-10 07:08:08 | Re: Feature Suggestion/Index tuning wizard that |
| Previous Message | Féliciano Matias | 2003-06-10 06:21:32 | Re: psql and bytea |