Mem2: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
There are 3 postgres instances running on mem2. | There are 3 postgres instances running on mem2. | ||
== Some useful commands == | == Some useful commands == | ||
<pre> \l \\ list all databases | |||
\dt \\ list all relations (or tables) | \dt \\ list all relations (or tables) | ||
\du \\ list all users | \du \\ list all users | ||
\dn \\ list all schemas | \dn \\ list all schemas | ||
\d+ table_name \\ list all table settings | \d+ [table_name] \\ list all table settings | ||
</pre> | |||
== List of databases: == | == List of databases: == | ||
Latest revision as of 19:20, 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+ [table_name] \\ list all table settings
List 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