gem-hunterHow to Run PostgreSQL Using Docker
How to Connect to a PostgreSQL Database With a Python Serverless Function
How to Connect to a Heroku Postgres Database With pgAdmin Using Docker
How to Run PostgreSQL and pgAdmin Using Docker
brew services start postgresql createuser -s postgres brew services restart postgresql brew unlink postgresql@13 brew link postgresql@12 brew info postgresql
psql -U mahbubzaman -d postgres
ALTER ROLE postgres WITH SUPERUSER;brew services restart postgresql@14 psql postgres # List of Roles \du Role name | Attributes | Member of -------------+------------------------------------------------------------+----------- mahbubzaman | Superuser | {} postgres | Superuser | {} # List of databases \l CREATE DATABASE DB_NAME; # Select the db \c DB_NAME # Show tables \dt # column listing \d table_name; # Quit \q # Export CSV COPY articles TO '/Users/xyz/Desktop/abc/article.csv' DELIMITER ',' CSV HEADER; # Import CSV COPY articles FROM '/Users/xyz/Desktop/abc/article.csv' DELIMITER ',' CSV HEADER;