Skip to content

Instantly share code, notes, and snippets.

@stephencweiss

stephencweiss/psql List of databases

Last active December 8, 2018 15:27
Show Gist options
  • Save stephencweiss/d0abf22aeb728ade266d85d55747332e to your computer and use it in GitHub Desktop.
Save stephencweiss/d0abf22aeb728ade266d85d55747332e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psql List of databases
#psql
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+---------+----------+-------------+-------------+---------------------
my_database | sdc | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/sdc +
| | | | | sdc=CTc/sdc
postgres | Stephen | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
sdc | Stephen | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/Stephen +
| | | | | Stephen=CTc/Stephen+
| | | | | sdc=CTc/Stephen
template0 | Stephen | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/Stephen +
| | | | | Stephen=CTc/Stephen
template1 | Stephen | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/Stephen +
| | | | | Stephen=CTc/Stephen
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment