authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_connection_string
Parameters
Name
Type
Mode
prop_id
integer
IN
Definition
/* .NET Connection String */ Select format( 'Host=%s;Port=%s;Username=%s;Password=%s;Database=%s;Timezone=%s', --'Host=%s;Port=%s;Username=%s;Password=%s;Database=%s', coalesce(db_host, 'db.fromas.cloud'), coalesce(db_port, '5432'), 'newsoft', 'News0ft@pg', coalesce(db_name, lower(code)), --'Asia/Vladivostok' (select param_value from fn_prop_params(prop_id,'SYSTEM','TIMEZONE', 'Asia/Bangkok')) -- fn_sys_param('TIMEZONE','Asia/Bangkok') ) FROM property p WHERE p.id = prop_id