all about postgres

postgres.md

Connect

psql -U postgres

Create Db

CREATE DATABASE my_test_db

List Db

\l

Use Db

\c my_test_db

List Tables

\d

Show Tables

\c database_name;

Alter Table

ALTER TABLE table_name ADD COLUMN IF NOT EXISTS column_name INTEGER;

ALTER TABLE table_name DROP COLUMN IF EXISTS column_name;

Connect DB

psql -U postgres -d northwind

Get comma separated data

You can use the array() and array_to_string() functions together with your query.
With SELECT array( SELECT id FROM table ); you will get a result like: {1,2,3,4,5,6}

Then, if you wish to remove the {} signs, you can just use the array_to_string() function and use comma as separator, so: SELECT array_to_string( array( SELECT id FROM table ), ',' ) will get a result like: 1,2,3,4,5,6

https://www.dataquest.io/blog/install-postgresql-14-7-for-macos/

pg_hba.conf path

psql -U postgres -c 'show hba_file'

Restart on mac

brew services restart postgresql@16