Re: Old/New

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-general by date

  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?