note 13904 added to ref.pgsql.php
| From: | hubert at hubertmuller dot com | Date: | Mon, 09 Jul 2001 20:36:41 +0000 |
| Subject: | note 13904 added to ref.pgsql.php | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-15130@lists.php.net to get a copy of this message | ||
The best way to find the separated list of tables, sequences, keys etc is:
SELECT relname FROM pg_class WHERE relkind='<value>' AND relname !~
'^pg_';
<value> takes:
i for keys,
r for relations,
S for sequences
Note that all tables names that begins with 'pg_' are PostgreSQL internal tables (this
explain why I use AND relname !~ '^pg_' condition).
http://www.php.net/manual/en/ref.pgsql.php