tips:db:postgres

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tips:db:postgres [2019/02/25 11:43] – [pgadmin] scipiotips:db:postgres [2019/03/13 09:55] (current) – [Basic operations] scipio
Line 33: Line 33:
 # list tables in schema # list tables in schema
 \dt auth.* \dt auth.*
 +
 +# describe table
 +\d+ auth.users
  
 # list of installed extensions # list of installed extensions
Line 121: Line 124:
 apt install wget python3-pip apt install wget python3-pip
 pip3 install -U pip pip3 install -U pip
-cd /tmp +pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.2/pip/pgadmin4-4.2-py2.py3-none-any.whl
-wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v3.5/pip/pgadmin4-3.5-py2.py3-none-any.whl +
-pip install ./pgadmin4-3.5-py2.py3-none-any.whl+
  
 # define ip binding # define ip binding
  • tips/db/postgres.1551091425.txt.gz
  • Last modified: 2019/02/25 11:43
  • by scipio