PostgreSQL Wire Protocol

Kinetica has support for PostgreSQL Wire Protocol connections. PostgreSQL simple query syntax is fully supported, while PostgreSQL extended query syntax is largely supported.

Connecting

Point any client able to make use of PostgreSQL Wire Protocol at Kinetica on port 5432 to connect.

JDBC

JDBC can be used to connect to PostgreSQL over PostgreSQL Wire Protocol.

JDBC Connection String Format

jdbc:postgresql://<db.host>:5432/postgres

JDBC Connection String Example

jdbc:postgresql://localhost:5432/postgres

PSQL

PSQL is a PostgreSQL CLI for connecting over PostgreSQL Wire Protocol.

Connect

psql -h <db.host> -U <username>

SELECT

=> SELECT * FROM example.vehicle;

Inspect

 id |  make   |      model
----+---------+------------------
 1  | Cord    | 812
 2  | Bugatti | La Voiture Noire

Psycopg

Psycopg is a Python library for connecting over PostgreSQL Wire Protocol.

Connect

>>> import psycopg2
>>> conn = psycopg2.connect(host="<db.host>", user="<username>", password="<password>")

SELECT

>>> cur = conn.cursor()
>>> cur.execute("SELECT * FROM example.vehicle")
>>> cur.fetchall()

Inspect

[('1', 'Cord', '812'), ('2', 'Bugatti', 'La Voiture Noire')]

​Connecting

​JDBC

​PSQL

​Psycopg

Connecting

JDBC

PSQL

Psycopg