Re: View the contents of a database - Mailing list pgsql-general

From Richard Huxton
Subject Re: View the contents of a database
Date
Msg-id 200208062008.38786.dev@archonet.com
Whole thread Raw
In response to View the contents of a database  (nuno.barros@fc.ul.pt (Nuno Barros))
List 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

pgsql-general by date:

Previous
From: Edwin Grubbs
Date:
Subject: inet <<= and indexes
Next
From: Richard Huxton
Date:
Subject: Re: Cannot use more than 16 attributes in an index