Skip to content

Instantly share code, notes, and snippets.

@wtodom

wtodom/gist:4736359

Created February 8, 2013 03:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wtodom/4736359 to your computer and use it in GitHub Desktop.
Save wtodom/4736359 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL \l table
Raw
gistfile1.txt
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
testdb | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres +
| | | | | postgres=CTc/postgres+
| | | | | wtodom=CTc/postgres
wtodom | wtodom | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment