Re: [GENERAL] Any way to SELECT a list of table names?

[Ken Godee]

On Sat, 10 Jan 2004, Eric Freeman wrote:


Is there any way in Postgres to SELECT a list of table names from inside of 
a C program using ECPG?
Something similar to SELECT current_user that will give you all of the 
tables in the database you are connected to.


Not sure if this is what you're trying to do but.......

"SELECT tablename FROM pg_tables where tablename not like 'pg_%'"

Will get a list of tables in the db you're connected to.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match