Mem2: Difference between revisions
Jump to navigation
Jump to search
(Created page with "There are 3 postgres instances running on mem2. == Some useful commands == \l \\ list all databases \dt \\ list all relations (or tables) \du \\ list all users \dn \\ lis...") |
(No difference)
|
Revision as of 19:18, 6 April 2022
There are 3 postgres instances running on mem2.
Some useful commands
\l \\ list all databases \dt \\ list all relations (or tables) \du \\ list all users \dn \\ list all schemas
\d+
\\ list all table settingsList of databases:
5432 (pgsql-9.2)
- amis
- blaster \\ tldr's db
- mwt
- shopcard \\ cartblanche's db
- side
- stage
- uploaddb
- zinc15
5433 (pgsql-12.1)
- chembl
- hg
- zinc21
5434 (pgsql-9.2)
- excipients