Re: Finding out table names

Kristen,

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.


Troy





>
> 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?
>
> Kristen
>