Skip to main content
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')]