🧠 PostgreSQL Connection Tools — psql vs pg

When you work with PostgreSQL, there are two common ways to connect and interact with your database:

1. psql → CLI (manual interaction, debugging, admin tasks)
2. pg → Node.js library (programmatic interaction inside your backend)

⚙️ 1. psql — Command-line Interface for PostgreSQL

📘 What it is:

psql is a terminal-based interactive shell for PostgreSQL.

It comes preinstalled when you install Postgres locally or via Docker.

You can use it to:

• Connect to databases
• Run SQL queries
• Manage users, tables, roles, and permissions
• Debug and inspect your DB manually

💡 Typical Usage (Syntax)

psql -h <host> -p <port> -U <username> -d <database>

Example:

psql -h localhost -p 5432 -U postgres -d mydb

or using password inline: