diff options
author | SVN Migration <svn@php.net> | 2003-02-27 17:43:39 +0000 |
---|---|---|
committer | SVN Migration <svn@php.net> | 2003-02-27 17:43:39 +0000 |
commit | 078bcec0997ad0e07b720c43cc9e6d0e046a75ab (patch) | |
tree | 36cb0f6be2ef078fe3374de8c087b93ecf82f812 /ext/pgsql/mysql_users.php | |
parent | fd61f69077f6156ca71dde60ecfd9ed9765a02db (diff) | |
download | php-git-PHP-5.tar.gz |
This commit was manufactured by cvs2svn to create branch 'PHP_5'.PHP-5
Diffstat (limited to 'ext/pgsql/mysql_users.php')
-rw-r--r-- | ext/pgsql/mysql_users.php | 82 |
1 files changed, 0 insertions, 82 deletions
diff --git a/ext/pgsql/mysql_users.php b/ext/pgsql/mysql_users.php deleted file mode 100644 index 65a2c33967..0000000000 --- a/ext/pgsql/mysql_users.php +++ /dev/null @@ -1,82 +0,0 @@ -<?php -/* - * File: mysql_users.php - * Author: Yasuo Ohgaki <yohgaki@php.net> - * - * This file contains example user defined functions that does - * similar to MySQL functions. They can be implemented as module - * functions, but there won't be many users need them. - * - * Requires: PostgreSQL 7.2.x - */ - -/* - * mysql_list_dbs() - * - * This function should be needed, since PostgreSQL connection - * binds database. - */ -function pg_list_dbs($db) -{ - assert(is_resource($db)); - $query = ' -SELECT - d.datname as "Name", - u.usename as "Owner", - pg_encoding_to_char(d.encoding) as "Encoding" -FROM - pg_database d LEFT JOIN pg_user u ON d.datdba = u.usesysid -ORDER BY 1; -'; - return pg_query($db, $query); -} - - -/* - * mysql_list_tables() - */ -function pg_list_tables($db) -{ - assert(is_resource($db)); - $query = " -SELECT - c.relname as \"Name\", - CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as \"Type\", - u.usename as \"Owner\" -FROM - pg_class c LEFT JOIN pg_user u ON c.relowner = u.usesysid -WHERE - c.relkind IN ('r','v','S','') - AND c.relname !~ '^pg_' -ORDER BY 1; -"; - return pg_query($db, $query); -} - -/* - * mysql_list_fields() - * - * See also pg_meta_data(). It returns field defintion as array. - */ -function pg_list_fields($db, $table) -{ - assert(is_resource($db)); - $query = " -SELECT - a.attname, - format_type(a.atttypid, a.atttypmod), - a.attnotnull, - a.atthasdef, - a.attnum -FROM - pg_class c, - pg_attribute a -WHERE - c.relname = '".$table."' - AND a.attnum > 0 AND a.attrelid = c.oid -ORDER BY a.attnum; -"; - return pg_query($db, $query); -} - -?> |