Re: How to list which tables are available?

To get a list of the non-default tables in your database, do this:

SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg_%';

If you really want all of the tables, including the ones PostgreSQL
creates by default, just do this:

SELECT tablename FROM pg_tables;

Hope this helps,
chet(at)crashed(dot)net

"B.W.H. van Beest" <bwvb(at)xs4all(dot)nl> wrote in message news:<3f8bc79c$0$58708$e4fe514c(at)news(dot)xs4all(dot)nl>...
> It seems so elementary, but how I get a list of which tables are
> available in a database. I can't find an SQL command for this, but there
> must be a way!
>
> Thanks.
>
> Bertwim