Mem2

From DISI
Jump to navigation Jump to search

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