Postgres Pro
Downloads
Home   >   mailing lists

Re: How to list which tables are available? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: How to list which tables are available?
Date
Msg-id Pine.LNX.4.44.0310142035130.22628-100000@peter.localdomain
Whole thread Raw
In response to How to list which tables are available?  ("B.W.H. van Beest" <bwvb@xs4all.nl>)
List pgsql-general
Tree view 
B.W.H. van Beest writes:

> It seems so elementary, but how I get a list of which tables are
> available in a database. I can't find an SQL command for this, but there
> must be a way!

SELECT * FROM pg_tables;

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Transaction Queries!!!
Next
From: "pw"
Date:
Subject: Re: converting varchar date strings to date