Hans Schou wrote:
> The dburl (or dburi) has become common to use by many systems connecting to a database.
> The feature is that one can pass all parameters in a string, which has similar pattern as
> http-URI do.
>
> Especially when using psql in a script, having the credentials in one string is
> convenient.
>
>
> The syntax could be:
>
> [scheme[<+>dsn]]://[[username[:[password]]@][host][:port][/[dbname][/[[table[/[column[,col
> umn...]*]]]|sql]]]
>
>
> Example of usage:
> psql pgsql://joe:p4zzw0rd@example.org:2345/dbname
[...]
> I have attached an example of how it could be implemented. It uses libpcre RegEx to pass
> the dburl.
Unless I misunderstand, this has been in PostgreSQL since 9.2:
https://www.postgresql.org/docs/current/static/libpq-connect.html#AEN45571https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b035cb9db7aa7c0f28581b23feb10d3c559701f6
Yours,
Laurenz Albe