note 42679 added to ref.pgsql
| From: | abondi at ijk dot it | Date: | Wed, 26 May 2004 09:11:15 +0000 |
| Subject: | note 42679 added to ref.pgsql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-70102@lists.php.net to get a copy of this message | ||
I've found another function to mimic the following mysql list tables function
(http://www.php.net/manual/en/function.mysql-list-tables.php) that's more useful for my target:
function pg_list_tables() {
$sql = "SELECT a.relname AS Name
FROM pg_class a, pg_user b
WHERE ( relkind = 'r') and relname !~ '^pg_' AND relname !~
'^sql_'
AND relname !~ '^xin[vx][0-9]+' AND b.usesysid = a.relowner
AND NOT (EXISTS (SELECT viewname FROM pg_views WHERE viewname=a.relname));";
return(pg_query($conn, $sql));
}
----
Manual Page -- http://www.php.net/manual/en/ref.pgsql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+42679
Delete -- http://master.php.net/manage/user-notes.php?action=delete+42679&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+42679&report=yes
Search -- http://master.php.net/manage/user-notes.php