postgresql-psql

Use psql with connection parameters: `psql -U username -d database_name -h hostname`. psql is PostgreSQL's command-line client that establishes interactive or scripted database sessions. Specify user, database name, and host; omit host for local connections via Unix socket.

Write SQL scripts and integrate them with Bash for automation. psql executes scripts with the `-f` flag and meta-commands, enabling scheduled backups, routine maintenance, and health monitoring without manual intervention across development and operations workflows.

Use `EXPLAIN` in psql to view query execution plans, then identify bottlenecks in table scans, joins, and sorts. psql also supports monitoring active queries and blocking sessions directly from the terminal to troubleshoot performance issues and optimize database operations.

Yes, psql's meta-commands handle object management: `\dt` lists tables, `\dv` lists views, `\df` lists functions. These commands simplify interactive database administration without writing SQL DDL statements, making schema exploration and object inspection efficient.

psql supports local sockets, remote TCP connections, SSL encryption, and SSH tunneling. Credential handling via connection strings, environment variables, and `.pgpass` files secures authentication across development, remote, and production database environments.

psql supports `COPY` for bulk data transfer and `\copy` for client-side import/export to CSV and text formats. These commands enable data migration, seeding, and backup workflows integrated with SQL scripting for streamlined data management tasks.