Kinetica has support for PostgreSQL Wire Protocol connections. PostgreSQL simple query syntax is fully supported, while PostgreSQL extended query syntax support will be coming soon.
Connecting
Point any client able to make use of PostgreSQL Wire Protocol at Kinetica on port 5432 to connect.
PSQL
PSQL is a PostgreSQL CLI for connecting over PostgreSQL Wire Protocol.
Specify the -d option to make ki_home the default home directory, if needed, as the default will be automatically set to the username by PSQL.
Connect
|
|
SELECT
|
|
Inspect
|
|
Psycopg
Psycopg is a Python library for connecting over PostgreSQL Wire Protocol.
Specify the dbname option to make ki_home the default home directory, if needed, as the default will be automatically set to the username by Psycopg.
Connect
|
|
SELECT
|
|
Inspect
|
|