postgis-assist 0.0.3

Package for Postgis query using python

Postgis Assist

The postgis-assist library is build on top of psycopg2. It will be really helpful for running the basic postgresql and postgis query in python.

Checkout the official documentation of this library here: postgis-assist.readthedocs.io/

Installation

For installation of postgis-assist, you need to run following command

pip install postgis-assist

Examples using this library

Please check the official documentation here: https://postgis-assist.readthedocs.io/.

#Library import
from postgis.pgis import pgis

# Initialization of library
db = pgis(dbname='pgtest', user='postgres', password='admin', host='localhost', port='5432')

# Run any query
db.run_query('SELECT * FROM pg_catalog.pg_tables')

# Create schema
db.create_schema(schema_name='schema_name')

# Delete schema
db.delete_schema(schema_name='schema_name')

# Create Table
db.create_table(table_name='table_name', schema_name='schema_name', columns='id serial PRIMARY KEY, name varchar(50)')

# Get geometry as geojson
db.vector_geojson(schema_name='schema_name', table_name='table_name')

# Upload vector file to database
db.load_vector(vector_path, schema_name="public", table_name="vector")