Differences

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

--- postgresql [2026/06/14 12:34] – created jhagstrand
+++ postgresql [2026/07/31 05:32] (current) – [Use] jhagstrand
@@ Line 3: / Line 3: @@
 ===== Installation =====
-sudo apt update
-sudo apt install postgresql postgresql-contrib postgis postgresql-16-postgis-3
-sudo -u postgres psql
+  sudo apt update
-CREATE USER devuser WITH PASSWORD 'devpass';
+  sudo apt install postgresql postgresql-contrib postgis postgresql-16-postgis-3
-CREATE DATABASE myapp OWNER devuser;
-\c myapp
+  sudo -u postgres psql
-CREATE EXTENSION postgis;
+  CREATE USER devuser WITH PASSWORD 'devpass';
+  CREATE DATABASE myapp OWNER devuser;
+  \c myapp
+  CREATE EXTENSION postgis;
+===== Use =====
+  psql -U voyccom_jhagstrand -d voyccom_mai
+  (password is in .pgpass)
+  \h list SQL commands
+  \? list psql commands
+  \dt list tables in public schema
+  SELECT * FROM information_schema.tables WHERE table_schema = 'mai';
+  SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'mai';
+  select table_schema, table_name from information_schema.tables where table_schema not in ('public','pg_catalog','information_schema') group by table_schema, table_name order by table_schema,table_name;