| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | adrian(dot)klaver(at)gmail(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Old/New |
| Date: | 2010-01-23 16:11:17 |
| Message-ID: | 4B5B1FA5.2070906@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 23/01/2010 15:51, Bob Pawley wrote:
> I havn't been able to find documentation on how to use \d. When I open
Hi Bob,
In brief:
\dt lists all the tables in the current schema
\d <tablename> gives the structure of the named table
.. and loads of others. The docs are here:
http://www.postgresql.org/docs/8.4/static/app-psql.html
See the section entitled "meta-commands", a good distance down the page.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2010-01-23 17:35:21 | Re: MySQL -> Postgres migration tools? |
| Previous Message | Grzegorz Jaśkiewicz | 2010-01-23 16:05:59 | Re: MySQL -> Postgres migration tools? |