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@crashed.net
"B.W.H. van Beest" <bwvb@xs4all.nl> wrote in message news:<3f8bc79c$0$58708$e4fe514c@news.xs4all.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
