Displaying 1 result from an estimated 1 matches for "datistemplate".
2007 May 11
1
postgres erros on RHEL 4
...datname, pu.usename AS datowner,
pg_encoding_to_char(encoding) AS datencoding,
(SELECT description FROM pg_description
pd WHERE pdb.oid=pd.objoid) AS datcomment
FROM pg_database pdb, pg_user pu
WHERE pdb.datdba = pu.usesysid
AND NOT pdb.datistemplate
ORDER BY pdb.datname
Why . Pls help me to solve this.
--
Thank you
Indunil Jayasooriya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20070511/7eb885fa/attachment.html>