Name:     Local PostgreSQL
Host:     localhost
Port:     5432
Username: postgres
Password: (mật khẩu của bạn)
Database: postgres

Name:     Docker Postgres
Host:     localhost
Port:     5432 (hoặc cổng đã map)
Username: postgres
Password: (mật khẩu từ POSTGRES_PASSWORD)
Database: postgres

Name:     Homebrew Postgres
Host:     localhost
Port:     5432
Username: (tên người dùng macOS của bạn)
Password: (để trống cho local trust auth)
Database: postgres

Name:     Production DB
Host:     db.example.com
Port:     5432
Username: app_user
Password: (mật khẩu an toàn)
Database: myapp_production

Name:     AWS RDS Postgres
Host:     mydb.abc123.us-east-1.rds.amazonaws.com
Port:     5432
Username: postgres
Password: (mật khẩu RDS của bạn)
Database: postgres

Name:     Heroku Postgres
Host:     ec2-xx-xxx-xxx-xxx.compute-1.amazonaws.com
Port:     5432
Username: (từ DATABASE_URL)
Password: (từ DATABASE_URL)
Database: (từ DATABASE_URL)

-- Truy vấn JSONB
SELECT data->>'name' as name, data->'address'->>'city' as city
FROM customers
WHERE data @> '{"active": true}'::jsonb;

-- Thao tác Array
SELECT name, tags
FROM products
WHERE 'electronics' = ANY(tags);

-- Window functions
SELECT
    department,
    employee,
    salary,
    salary - LAG(salary) OVER (PARTITION BY department ORDER BY hire_date) as salary_change
FROM employees;

-- CTEs với RETURNING
WITH inserted AS (
    INSERT INTO orders (customer_id, total)
    VALUES (1, 99.99)
    RETURNING *
)
SELECT * FROM inserted;

-- Full-text search
SELECT title, ts_rank(search_vector, query) as rank
FROM articles, to_tsquery('english', 'database & performance') query
WHERE search_vector @@ query
ORDER BY rank DESC;

# TYPE  DATABASE        USER            ADDRESS                 METHOD
local   all             all                                     trust
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

CREATE DATABASE myapp;

SELECT * FROM pg_extension;

EXPLAIN ANALYZE
SELECT * FROM users WHERE email LIKE '%@example.com';

SELECT count(*) FROM pg_stat_activity;