/docs/MyDocs

To get this branch, use:
bzr branch http://darksoft.org/webbzr/docs/MyDocs

« back to all changes in this revision

Viewing changes to DataBase/PgSQL/pgsql.txt

  • Committer: Suren A. Chilingaryan
  • Date: 2009-04-09 03:21:08 UTC
  • Revision ID: csa@dside.dyndns.org-20090409032108-w4edamdh4adrgdu3
import

Show diffs side-by-side

added added

removed removed

Lines of Context:
DataBase/PgSQL/pgsql.txt
 
1
SELECT d.datname as "Name",
 
2
      u.usename as "Owner",
 
3
      pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
 
4
FROM pg_catalog.pg_database d
 
5
 LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
 
6
ORDER BY 1;