[GENERAL] Re: Feature proposal, DBURL: psqlpgsql://joe:p4zzw0rd@example.org:2345/dbname - Mailing list pgsql-general

From Thomas Kellerer
Subject [GENERAL] Re: Feature proposal, DBURL: psqlpgsql://joe:p4zzw0rd@example.org:2345/dbname
Date
Msg-id ojit3t$boc$1@blaine.gmane.org
Whole thread Raw
In response to [GENERAL] Feature proposal, DBURL: psql pgsql://joe:p4zzw0rd@example.org:2345/dbname  (Hans Schou <hans.schou@gmail.com>)
Responses Re: [GENERAL] Re: Feature proposal, DBURL: psql pgsql://joe:p4zzw0rd@example.org:2345/dbname  (Hans Schou <hans.schou@gmail.com>)
List pgsql-general
Hans Schou schrieb am 05.07.2017 um 14:27:
> 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[,column...]*]]]|sql]]]

Besides the fact that something like that is already possible:

What's the use of "table" and "column" in the URI? You connect to a database, not to a table.

Thomas

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [GENERAL] pg_start/stop_backup non-exclusive scripts to snapshot
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12