note 42679 added to ref.pgsql

From: 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

« previous php.notes (#70102) next »