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"
};