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 [2018/10/11 14:32] – [Basic operations] 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
 \dx \dx
 +
 +# enable expanded display
 +\x
 </code> </code>
  
Line 82: Line 88:
 <code> <code>
 createuser -P -s -e admin createuser -P -s -e admin
 +</code>
 +
 +
 +create user and database for sentry
 +<code>
 +CREATE ROLE sentry WITH PASSWORD 'blabla' LOGIN;
 +CREATE DATABASE sentry ENCODING 'UTF8' OWNER sentry;
 </code> </code>
 ==== developer containers ===== ==== developer containers =====
Line 111: 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/v2.0/pip/pgadmin4-2.0-py2.py3-none-any.whl +
-pip install ./pgadmin4-2.0-py2.py3-none-any.whl+
  
 # define ip binding # define ip binding
  • tips/db/postgres.1539261134.txt.gz
  • Last modified: 2018/10/11 14:32
  • by scipio