Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I make a query return all table names? - Mailing list pgsql-general

From Alain Picard
Subject Re: How do I make a query return all table names?
Date
Msg-id 86r8nb5wea.fsf@gondolin.local.net
Whole thread Raw
List pgsql-general
Tree view 
konradatwork@hotmail.com (Konrad) writes:

> I just want to send a query to the db that returns a list of all names
> of all of the tables in the current database.
>
> Is there such a query?

select * from pg_tables;


--
It would be difficult to construe        Larry Wall, in  article
this as a feature.             <1995May29.062427.3640@netlabs.com>

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: help with getting index scan
Next
From: "Kelly McTiernan"
Date:
Subject: Re: Work Around For Oracle Feature