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

pg_hba.conf path

psql -U postgres -c 'show hba_file'

Restart on mac

brew services restart postgresql@16