Magnus Landahl wrote:
>Hi everybody!
>
>Is it possible to get the names of all tables in the database with a sql
>query??
>
>Best regards,
>
>Magnus
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
Not sure if this is the best way, but it works. SELECT relname , relowner from pg_class where relkind = 'r';
The only thing is that this includes system tables.
So if you want to strip those you need to SELECT relname , relowner FROM pg_class WHERE relkind = 'r' and
relowner != 26;
Is user postgres always 26? Maybe you have to find that out first.
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 553-8000 x???
dado@wildbrain.com San Francisco, CA.