Re: How to list which tables are available?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "B(dot)W(dot)H(dot) van Beest" <bwvb(at)xs4all(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to list which tables are available?
Date: 2003-10-14 18:35:26
Message-ID: Pine.LNX.4.44.0310142035130.22628-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pw 2003-10-14 18:39:50 Re: converting varchar date strings to date
Previous Message CoL 2003-10-14 18:31:48 Re: Excute comnands OS from plpgsql