[GENERAL] Feature proposal, DBURL: psql pgsql://joe:p4zzw0rd@example.org:2345/dbname

Поиск
Список
Период
Сортировка
Hi

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]]]

Example of usage:
  psql pgsql://joe:p4zzw0rd@example.org:2345/dbname

Where
  Scheme: pgsql
  Username: joe
  Password: p4zzw0rd
  Host: example.org
  Port: 2345
  Database: dbname

I have attached an example of how it could be implemented. It uses libpcre RegEx to pass the dburl.

best regards
Hans
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: PAWAN SHARMA
Дата:
Сообщение: Re: [SPAM] [GENERAL] How to install pgadmin3 or pgadmin4 on linux machine
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: [GENERAL] [ADMIN] How to install pgadmin3 or pgadmin4 on linux machine