Back to index

php5  5.3.10
Functions
mysql_users.php File Reference

Go to the source code of this file.

Functions

 pg_list_dbs ($db)
 pg_list_tables ($db)
 pg_list_fields ($db, $table)

Function Documentation

pg_list_dbs ( db)

Definition at line 19 of file mysql_users.php.

{
        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);
}
pg_list_fields ( db,
table 
)

Definition at line 61 of file mysql_users.php.

{
        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);
}
pg_list_tables ( db)

Definition at line 38 of file mysql_users.php.

{
        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);
}