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 [EMAIL PROTECTED] 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???
[EMAIL PROTECTED] San Francisco, CA.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
