FilesExpand file tree

 immutable-date

/

mysql_users.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

82 lines (77 loc) · 1.64 KB

 immutable-date

/

mysql_users.php

Copy path

Top

File metadata and controls

• Code
• Blame

82 lines (77 loc) · 1.64 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

<?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);

}

?>