Skip to content

Instantly share code, notes, and snippets.

@vinnix
Created June 4, 2012 17:08
Show Gist options
  • Save vinnix/2869575 to your computer and use it in GitHub Desktop.
Save vinnix/2869575 to your computer and use it in GitHub Desktop.
postgres=# \l+
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges | Size | Tablespace | Description
------------+------------+----------+-----------+-------+-----------------------+---------+---------------+---------------------------
biocinese | site | LATIN1 | en_US | en_US | =Tc/site | 7078 kB | ts_biocinese |
: site=CTc/site
: qualidade=CTc/site
curriculo | intranet | LATIN1 | en_US | en_US | | 21 MB | ts_curriculo |
firewall | giovanni | LATIN1 | en_US | en_US | | 5670 kB | ts_firewall |
intranet | intranet | LATIN1 | en_US | en_US | intranet=CTc/intranet | 2167 MB | ts_intranet |
: =Tc/intranet
nds | nds | LATIN1 | en_US | en_US | | 22 MB | ts_nds |
postgres | postgres | LATIN1 | en_US | en_US | | 5606 kB | pg_default |
pratidw | pratidw | LATIN1 | en_US | en_US | | 14 MB | ts_pratidw |
ps | telenew | LATIN1 | en_US | en_US | =CTc/telenew | 338 MB | ts_ps |
: telenew=CTc/telenew
pykota | pykota | LATIN1 | en_US | en_US | | 789 MB | ts_pykota |
pykota_old | pykota | LATIN1 | en_US | en_US | | 309 MB | ts_pykota |
rcpd | telenew | LATIN1 | en_US | en_US | | 340 MB | ts_rcpd |
serprati | telenew | LATIN1 | en_US | en_US | | 17 MB | ts_serprati |
sivcm | wssiv | LATIN1 | en_US | en_US | | 3510 MB | ts_wssiv |
televendas | televendas | LATIN1 | en_US | en_US | | 53 GB | ts_televendas |
template0 | postgres | LATIN1 | en_US | en_US | =c/postgres | 5408 kB | pg_default |
: postgres=CTc/postgres
template1 | postgres | LATIN1 | en_US | en_US | postgres=CTc/postgres | 5510 kB | pg_default | default template database
: =c/postgres
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment