$HOME/.pg service.conf

$HOME/.pg_service.conf

• https://www.postgresql.org/docs/13/libpq-pgservice.html

touch $HOME/.pg_service.conf
# My comment for mydb
[MyDB] 
host=somehost 
port=5432 
dbname=test
user=admin

psql service=MyDB
https://stackoverflow.com/a/39097994

[MySecondDB]
host=localhost
port=5432
dbname=test
user=admin
password=your_password

Related terms

• .ssh/config
• su - postgres
• Show tables
• List users
• aws rds describe-db-instances | grep -w DBInstanceIdentifier
• $HOME/.psqlrc

See also

• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql
• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, \conninfo, --version, --help, PL/pgSQL