The postgres lib cannot parse my url string correctly to connect to my local postgresql

[janydoe]

I try to set postgresql://user@localhost/db?host=/run/postgresql and postgresql:///db?host=/run/postgresql but seems it doesn't work. You get replace all query parameters here

Specification:
https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING-URIS

You can use pg-connection-string package

but actually we can use URL to parse it

new URL('postgresql://user:pass@localhost:5432/db?host=/run/postgresql')
URL {
  href: 'postgresql://user:pass@localhost:5432/db?host=/run/postgresql',
  origin: 'null',
  protocol: 'postgresql:',
  username: 'user',
  password: 'pass',
  host: 'localhost:5432',
  hostname: 'localhost',
  port: '5432',
  pathname: '/db',
  search: '?host=/run/postgresql',
  searchParams: URLSearchParams { 'host' => '/run/postgresql' },
  hash: ''
}

new URL('postgresql:///db?host=/run/postgresql')
URL {
  href: 'postgresql:///db?host=/run/postgresql',
  origin: 'null',
  protocol: 'postgresql:',
  username: '',
  password: '',
  host: '',
  hostname: '',
  port: '',
  pathname: '/db',
  search: '?host=/run/postgresql',
  searchParams: URLSearchParams { 'host' => '/run/postgresql' },
  hash: ''
}