Package for Postgis query using python
Project description
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")
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
postgis-assist-0.0.3.tar.gz
(4.2 kB
view hashes)
Built Distribution
Close
Hashes for postgis_assist-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fcc3d7dcae0c76b4c88fafeb1a90d269e4811ac065e9aacc07ee9e6a381b7af1 |
|
MD5 | 6c4ac2216c9389694ec1659f571e7cfa |
|
BLAKE2b-256 | 155a09261260886ac4b56e5605a169766d546826098752be65a5e2a6749c4d92 |