Re: View the contents of a database

From: Richard Huxton <dev(at)archonet(dot)com>
To: nuno(dot)barros(at)fc(dot)ul(dot)pt (Nuno Barros), pgsql-general(at)postgresql(dot)org
Subject: Re: View the contents of a database
Date: 2002-08-06 19:08:38
Message-ID: 200208062008.38786.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 06 Aug 2002 11:36 am, Nuno Barros wrote:
> I am a beginner with Postgres and my question is quite simple.
> I want to make a query to see the contents of a database, i mean, see
> wich tables exist in a database.

At the psql prompt use the "\d" command - use "\?" to see other commands
available. Check the manual for full details of psql.

The "\d" command is just a shortcut for standard sql - you can start psql with
a -E flag to see how it does it.

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-08-06 19:10:49 Re: MySQL or Postgres ?
Previous Message Ralph Graulich 2002-08-06 19:07:44 Re: Cannot use more than 16 attributes in an index