Port details on branch 2022Q2 |
- py-postgresql Python 3 compatible PostgreSQL database driver and tools
- 1.3.0 databases =0 1.3.0Version of this port present on the latest quarterly branch.
- Maintainer: arcade@b1t.name
- Port Added: 2009-12-18 19:23:01
- Last Update: 2023-06-27 19:34:34
- Commit Hash: 3d9a815
- Also Listed In: python
- License: BSD3CLAUSE
- WWW:
- https://github.com/python-postgres/fe
- Description:
- Pure Python
All code, at first, is written in pure Python so that py-postgresql will work
anywhere that you can install Python 3. Optimizations in C are made where
needed, but are always optional.
Prepared Statements
Using the PG-API interface, protocol-level prepared statements may be created
and used multiple times. db.prepare(sql)(*args)
COPY Support
Use the convenient COPY interface to directly copy data from one connection to
another. No intermediate files or tricks are necessary.
Arrays and Composite Typescw
Arrays and composites are fully supported. Queries requesting them will returns
objects that provide access to the elements within.
"pg_python" Quick Console
Get a Python console with a connection to PostgreSQL for quick tests and simple
scripts.
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - There is no configure plist information for this port.
- Dependency lines:
-
- ${PYTHON_PKGNAMEPREFIX}postgresql>0:databases/py-postgresql@${PY_FLAVOR}
- To install the port:
- cd /usr/ports/databases/py-postgresql/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/py-postgresql
- pkg install py39-postgresql
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above. NOTE: This is a Python port. Instead of py39-postgresql listed in the above command, you can pick from the names under the Packages section.- PKGNAME: py39-postgresql
- Package flavors (<flavor>: <package>)
- distinfo:
- TIMESTAMP = 1676332838
SHA256 (postgresql/py-postgresql-1.3.0.tar.gz) = fca0f04d3f7478bd59c29c051e979d75b54be01545bd619eba2a3ed322a32c6e
SIZE (postgresql/py-postgresql-1.3.0.tar.gz) = 273764
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- py39-setuptools>=63.1.0 : devel/py-setuptools@py39
- python3.9 : lang/python39
- Test dependencies:
-
- python3.9 : lang/python39
- Runtime dependencies:
-
- py39-setuptools>=63.1.0 : devel/py-setuptools@py39
- python3.9 : lang/python39
- Library dependencies:
-
- libpq.so.5 : databases/postgresql13-client
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- databases_py-postgresql
- USES:
- pgsql python
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|