authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_connection
Description
Create connection string
Parameters
Name
Type
Mode
db_name
text
IN
db_host
text
IN (DEFAULT 'localhost')
db_port
integer
IN (DEFAULT 5432)
Definition
--select format('postgresql://%L:%L@$L:%L/%L', postgres, 'Newsoft@pg', coalesce(db_host, 'localhost'), coalesce(db_port, 5432), db_name) -- require URI encode Select 'host='||coalesce(db_host, 'localhost') ||' dbname='||db_name ||' port='||coalesce(db_port, 5432) ||' user=postgres password=News0ft@pg';