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
>
