Sorry, looks like you wanted > 0 so should have been:
(c.relhastriggers = 't') AS "Has Triggers",
> I'm showing in PostgreSQL 8.3.3 has the field reltriggers, but in
> 8.4.0 the
> field no longer exists and looks like may have been replaced with
> which is boolean? Try:
> SELECT c.relname AS "Name",
> n.nspname AS "Schema",
> pg_get_userbyid(c.relowner) AS "Owner",
> t.spcname AS "Tablespace",
> c.relhasindex AS "Has Indexes",
> c.relhasrules AS "Has Rules",
> (c.relhastriggers = 'f') AS "Has Triggers",
> c.relisshared AS "Is Shared",
> c.relnatts AS "N Cols",
> pg_catalog.obj_description(c.oid, 'pg_class') AS "Comment"
> FROM pg_class c
> LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
> LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
> WHERE c.relkind = 'r'::"char"
> AND n.nspname LIKE 'public'
> AND c.relname LIKE '%'
> ORDER BY n.nspname, c.relname
In response to
pgsql-jdbc by date
|Next:||From: Eric Jain||Date: 2009-10-20 00:31:31|
|Subject: How to ensure that SSL is enabled?|
|Previous:||From: dmp||Date: 2009-10-19 20:51:39|
|Subject: Re: ERROR : column c.reltriggers does not exist|