Difference between revisions of "$HOME/.pg service.conf"

From wikieduonline
Jump to navigation Jump to search
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
* Configuration: <code>[[$HOME]]/.pg_service.conf</code>
 +
* Connection: <code>psql service=YourDBpage</code>
 +
 
* https://www.postgresql.org/docs/13/libpq-pgservice.html
 
* https://www.postgresql.org/docs/13/libpq-pgservice.html
  
Line 6: Line 9:
 
  host=somehost  
 
  host=somehost  
 
  port=5432  
 
  port=5432  
  dbname=test
+
  [[dbname]]=test
 
  user=admin
 
  user=admin
 
  
 
  [[psql]] service=MyDB
 
  [[psql]] service=MyDB
Line 19: Line 21:
 
  user=admin
 
  user=admin
 
  password=your_password
 
  password=your_password
 
  
 
== Related terms ==
 
== Related terms ==
* <code>[[.ssh/config]]</code>
 
 
* <code>[[su - postgres]]</code>
 
* <code>[[su - postgres]]</code>
* [[Show tables]]
+
* [[Show tables]], [[List users]]
 
* <code>[[aws rds describe-db-instances]] | grep -w [[DBInstanceIdentifier]]</code>
 
* <code>[[aws rds describe-db-instances]] | grep -w [[DBInstanceIdentifier]]</code>
 +
* <code>[[$HOME/.psqlrc]]</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 09:04, 16 August 2022

Advertising: