PostgreSQL

Install

Install dependencies for Ibis’s PostgreSQL dialect:

pip install 'ibis-framework[postgres]'

or

conda install -c conda-forge ibis-postgres

Connect

Create a client by passing a connection string to the url parameter or individual parameters to ibis.postgres.connect():

con = ibis.postgres.connect(
    url='postgresql://postgres:postgres@postgres:5432/ibis_testing'
)
con = ibis.postgres.connect(
    user='postgres',
    password='postgres',
    host='postgres',
    port=5432,
    database='ibis_testing',
)

API

The PostgreSQL client is accessible through the ibis.postgres namespace.

Use ibis.postgres.connect with a SQLAlchemy-compatible connection string to create a client.

Backend.connect(*args, **kwargs)	Return new client object with saved args/kwargs, having called .reconnect() on it.
Backend.database([name])	Return a Database object for the name database.
Backend.list_tables([like, database])	Return the list of table names in the current database.
Backend.list_databases([like])	List databases in the current server.
Backend.table(name[, database, schema])	Create a table expression that references a particular a table called name in a PostgreSQL database called database.