PostgreSQL Connection URIs

標籤：res   pos   one   syntax   ogr   param   ...   optional   arc   

摘自官方文檔：

The general form for a connection URI is:

postgresql://[user[:password]@][netloc][:port][/dbname][?param1=value1&...]

The URI scheme designator can be either postgresql:// or postgres://. Each of the URI parts is optional. The following examples illustrate valid URI syntax uses:

postgresql://postgresql://localhostpostgresql://localhost:5433postgresql://localhost/mydbpostgresql://[email protected]postgresql://user:[email protected]postgresql://[email protected]/otherdb?connect_timeout=10&application_name=myapp

Components of the hierarchical part of the URI can also be given as parameters. For example:

postgresql:///mydb?host=localhost&port=5433

PostgreSQL Connection URIs