Differences

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

--- tips:db:postgres [2018/05/03 14:54] – [pgmodeler] scipio
+++ tips:db:postgres [2019/03/13 09:55] (current) – [Basic operations] scipio
@@ Line 20: / Line 20: @@
 ===== Basic operations =====
+<code>
+# list databases
+\l
+# connect to database
+\c giano
+# list schema
+\dn
+# list tables in schema
+\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>
 drop role gianoauth
@@ Line 53: / Line 83: @@
 ALTER USER gianoauth SET search_path TO auth;
 ALTER ROLE gianoauth IN DATABASE giano SET search_path TO auth;
+</code>
+create superuser <admin> with password
+<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 82: / 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