Mem2: Difference between revisions

From DISI
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...")
 
Line 5: Line 5:
  \du \\ list all users
  \du \\ list all users
  \dn \\ list all schemas
  \dn \\ list all schemas
  \d+ <table> \\ list all table settings
  \d+ table_name \\ list all table settings
 
== List of databases: ==
== List of databases: ==
=== 5432 (pgsql-9.2) ===
=== 5432 (pgsql-9.2) ===

Revision as of 19:19, 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