PostgreSQL
To copy data from or write transformed data to a PostgreSQL table using Upsolver, you must first create a connection that provides the appropriate credentials to access your database
Syntax
CREATE POSTGRES CONNECTION <connection_identifier>
CONNECTION_STRING = '<connection_string>'
USER_NAME = '<user_name>'
PASSWORD = '<password>'
[ COMMENT = '<comment>' ]
Jump to
Connection options
CONNECTION_STRING
— editable
CONNECTION_STRING
— editableType: text
The connection string to use when connecting to the database. This string can be copied directly from PostgreSQL.
USER_NAME
— editable
USER_NAME
— editableType: text
The user to authenticate to the database with.
PASSWORD
— editable
PASSWORD
— editableType: text
The password for the user.
COMMENT
— editable
COMMENT
— editableType: text
(Optional) A description or comment regarding this connection.
Example
CREATE POSTGRES CONNECTION postgress_connection
CONNECTION_STRING = 'jdbc:
postgresql://cdc2.c02eyuedjkh9.eu-west-1.rds.amazonaws.com:5432/auction'
USER_NAME = 'your username'
PASSWORD = 'your password';
Last updated