On Feb 5, 2008, at 9:10 PM, johnf wrote:
> BTW if you use information_schema
>
> SELECT table_name,table_schema
> FROM information_schema.tables
> WHERE table_type = 'BASE TABLE'
> AND table_schema NOT IN
> ('pg_catalog', 'information_schema');
>
> will get the tables.
>
> I know you don't like information_schema but maybe it is time we
> reconsider.
No, since it seems that that may run into permission problems for
regular users.
How about this syntax:
select relname from pg_class where relkind= 'r' ;
I've found it on a couple of sites, and it doesn't seem to be subject
to the same permission limitations. Does it work for you?
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
