Difference between revisions of "Mem2"

From DISI
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 ==
\l \\ list all databases
+
<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