Here's what I use.
SELECT relname FROM pg_class WHERE relkind='r' and relname NOT LIKE 'pg_%' order by relname
Obviously, if you have tables which start with "pg_," then this solution
is not going to work.
I don't know how orthodox this solution is, or whether there are
serious problems with it. Maybe we'll find out now.
> I'm doing some database programming using Java/JDBC. I'd
> like to know how to find the table names contained in a
> database/schema. Is there an SQL statement for doing that?
In response to
pgsql-sql by date
|Next:||From: Tim Johnson||Date: 2000-04-20 01:28:01|
|Subject: Re: GROUPING and ORDERING and CONFUSION|
|Previous:||From: Kristen Nostrand||Date: 2000-04-19 19:10:49|
|Subject: Finding out table names|