Changes between Version 5 and Version 6 of CookBook Postgres Advanced Use

Timestamp:

Mar 4, 2010 1:45:28 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook Postgres Advanced Use

@@ -5 +5 @@
 \d
 }}}
+{{{
+SELECT n.nspname as "Schema",
+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_catalog.pg_class c
+LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner
+LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
+WHERE c.relkind IN ('r','')
+AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
+AND pg_catalog.pg_table_is_visible(c.oid)
+ORDER BY 1,2;
+}}}
+{{{
+select c.relname as tablename FROM pg_catalog.pg_class c
+LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
+WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
+AND pg_catalog.pg_table_is_visible(c.oid);
+}}}
+
+note : aucune de ces commandes ne fonctionne si la base n'est pas en UTF8