Differences

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

--- tips:db:postgres [2018/10/11 08:47] – [Basic operations] scipio
+++ tips:db:postgres [2019/03/13 09:55] (current) – [Basic operations] scipio
@@ Line 34: / Line 34: @@
 \dt auth.*
+# describe table
+\d+ auth.users
+# list of installed extensions
+\dx
+# enable expanded display
+\x
+</code>
+set search path for database
+<code>
+psql <database>
+ALTER DATABASE database_name SET search_path TO schema_name,public;
 </code>
@@ Line 74: / Line 88: @@
 <code>
 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>
 ==== developer containers =====
@@ Line 103: / Line 124: @@
 apt install wget python3-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