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,
[EMAIL PROTECTED]
"B.W.H. van Beest" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
