PostgreSQL#
The connection to PostgreSQL is based on the psycopg2 library.
Dependency#
psycopg2
Parameters#
Required:
user is the database user.
password is the database password.
host is the host name, IP address, or URL.
port is the port used to make TCP/IP connection.
database is the database name.
Warning
Provide the parameters of an already running PostgreSQL
server. EvaDB only connects to an existing PostgreSQL
database.
Create Connection#
CREATE DATABASE postgres_data WITH ENGINE = 'postgres', PARAMETERS = {
"user": "eva",
"password": "password",
"host": "localhost",
"port": "5432",
"database": "evadb"
};