version
---------------------------------------------------------------
PostgreSQL 7.3.2 on i586-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)
View "pg_catalog.pg_tables"
Column | Type | Modifiers
-------------+---------+-----------
schemaname | name |
tablename | name |
tableowner | name |
hasindexes | boolean |
hasrules | boolean |
hastriggers | boolean |
View definition: SELECT n.nspname AS schemaname, c.relname AS tablename,
pg_get_userbyid(c.relowner) AS tableowner, c.relhasindex AS hasindexes, c.relhasrules
AS hasrules, (c.reltriggers > 0) AS hastriggers FROM (pg_class c LEFT JOIN
pg_namespace n ON ((n.oid = c.relnamespace))) WHERE ((c.relkind = 'r'::"char") OR
(c.relkind = 's'::"char"));
Given that 'S' => Sequence and 's' => special shouldn't the last condition in the
WHERE clause be:
c.relkind = 'S'::"char"
instead of
c.relkind = 's'::"char"
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
