pgcopylib
Library for reading data from binary format PosgreSQL
Features
- No dependencies on external libraries
- Without specifying data types, all columns will be read in bytes
- Support for most data types
Supported Data Types
| PostgreSQL data type | Python data type |
|---|---|
| _bit | list[str] |
| _bool | list[bool] |
| _box | list[tuple[tuple[float, float], tuple[float, float]]] |
| _bpchar | list[str] |
| _bytea | list[bytes] |
| _char | list[str] |
| _cidr | list[ipaddress.IPv4Network / ipaddress.IPv6Network] |
| _circle | list[tuple[float, float, float]] |
| _date | list[datetime.date] |
| _float4 | list[float] |
| _float8 | list[float] |
| _inet | list[ipaddress.IPv4Address / ipaddress.IPv6Address] |
| _int2 | list[int] |
| _int4 | list[int] |
| _int8 | list[int] |
| _interval | list[dateutil.relativedelta.relativedelta] |
| _json | list[dict / list / str / int / float / bool / None] |
| _jsonb | list[dict / list / str / int / float / bool / None] |
| _line | list[tuple[float, float, float]] |
| _lseg | list[list[tuple[float, float]]] |
| _macaddr | list[str] |
| _macaddr8 | list[str] |
| _money | list[float] |
| _numeric | list[decimal.Decimal] |
| _oid | list[int] |
| _path | list[list[tuple[float, float]] / tuple[tuple[float, float]]] |
| _point | list[tuple[float, float]] |
| _polygon | list[tuple[tuple[float, float]]] |
| _serial2 | list[int] |
| _serial4 | list[int] |
| _serial8 | list[int] |
| _text | list[str] |
| _time | list[datetime.time] |
| _timestamp | list[datetime.datetime] |
| _timestamptz | list[datetime.datetime] |
| _timetz | list[datetime.time] |
| _uuid | list[uuid.UUID] |
| _varbit | list[str] |
| _varchar | list[str] |
| _xml | list[str] |
| bit | str |
| bool | bool |
| box | tuple[tuple[float, float], tuple[float, float]] |
| bpchar | str |
| bytea | bytes |
| char | str |
| cidr | ipaddress.IPv4Network / ipaddress.IPv6Network |
| circle | tuple[float, float, float] |
| date | datetime.date |
| float4 | float |
| float8 | float |
| inet | ipaddress.IPv4Address / ipaddress.IPv6Address |
| int2 | int |
| int4 | int |
| int8 | int |
| interval | dateutil.relativedelta.relativedelta |
| json | dict / list / str / int / float / bool / None |
| jsonb | dict / list / str / int / float / bool / None |
| line | tuple[float, float, float] |
| lseg | list[tuple[float, float]] |
| macaddr | str |
| macaddr8 | str |
| money | float |
| numeric | decimal.Decimal |
| oid | int |
| path | list[tuple[float, float]] / tuple[tuple[float, float]] |
| point | tuple[float, float] |
| polygon | tuple[tuple[float, float]] |
| serial2 | int |
| serial4 | int |
| serial8 | int |
| text | str |
| time | datetime.time |
| timestamp | datetime.datetime |
| timestamptz | datetime.datetime |
| timetz | datetime.time |
| uuid | uuid.UUID |
| varbit | str |
| varchar | str |
| xml | str |
Installation
From pip
pip install pgcopylib
From local directory
pip install .
From git
pip install git+https://github.com/0xMihalich/pgcopylib
1 maintainer
Metadata
1 maintainer
Release files for pgcopylib 0.2.3.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distributions (wheels)
Total release size: 16.7 MB
Release files / pgcopylib-0.2.3.3-cp314-cp314-win_amd64.whl
| Download URL | pgcopylib-0.2.3.3-cp314-cp314-win_amd64.whl |
|---|---|
| Size | 336.5 kB |
| Tags | CPython 3.14 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
096a2b88cdbb6a7071463c0a1b00c59c15d60917f8cd426ad203b88a157224bc
|
|
BLAKE2b-256 checksum How to use checksums |
4153852b107ebe63f743b85d296a756e561771f55a7fc791bad9c12c45228be7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 2.3 MB |
| Tags | CPython 3.14 Linux glibc 2.17+ x86-64 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
29985579107218664caf82a77de97768398e1abfc2ad48fa1e144c9e6f32d753
|
|
BLAKE2b-256 checksum How to use checksums |
80a9a2ca64d426cd1d6db8e0505e50892f1bf68b4766e8e2f6818914597f942a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp314-cp314-macosx_11_0_arm64.whl
| Download URL | pgcopylib-0.2.3.3-cp314-cp314-macosx_11_0_arm64.whl |
|---|---|
| Size | 366.0 kB |
| Tags | CPython 3.14 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
8ceacc2266f05ce6722e66489d7022eb0fc4c736ddb5eefb4f8fbc9084d36869
|
|
BLAKE2b-256 checksum How to use checksums |
d37e34902a998a80588e1aa15ef0579b50614cc43a5b3a6f82d1531eb8eed82e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp314-cp314-macosx_10_15_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp314-cp314-macosx_10_15_x86_64.whl |
|---|---|
| Size | 368.2 kB |
| Tags | CPython 3.14 macOS 10.15+ x86-64 |
|
SHA-256 checksum How to use checksums |
bc431228352ecd4a1e0d2744daccb78537f1f2beb2d9ef176d7b8df58871d86d
|
|
BLAKE2b-256 checksum How to use checksums |
b0fdcf5010a6aa80a346c3f7daee43ab01c06e80a6a84625b667b3f94d23349d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp313-cp313-win_amd64.whl
| Download URL | pgcopylib-0.2.3.3-cp313-cp313-win_amd64.whl |
|---|---|
| Size | 328.1 kB |
| Tags | CPython 3.13 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
df93fdc8f9de7a14e92909c18b96c2c033d639175889a1342f069f920daedf63
|
|
BLAKE2b-256 checksum How to use checksums |
a9c229c74e015f15d604cd4cf356cc5ff53f4aa0998b7f59869bea35bead4b17
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 2.3 MB |
| Tags | CPython 3.13 Linux glibc 2.17+ x86-64 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
837d46eb40dc6eb2ee740582100177c908833d5d29c81c1daacaaf90eb7e7c01
|
|
BLAKE2b-256 checksum How to use checksums |
b0c66cc8e810b516a62cf188dd6ff21b14a5099eba75cbe3e64fb45d8a67752c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp313-cp313-macosx_11_0_arm64.whl
| Download URL | pgcopylib-0.2.3.3-cp313-cp313-macosx_11_0_arm64.whl |
|---|---|
| Size | 364.5 kB |
| Tags | CPython 3.13 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
1818f44c548eed7d5c1137ec5e200189f5dc02497422d0914257adc3174c9423
|
|
BLAKE2b-256 checksum How to use checksums |
0564ddfdc97820442d17126343de8de5b9dff3ff9de0edf5b55ee493db128005
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp313-cp313-macosx_10_14_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp313-cp313-macosx_10_14_x86_64.whl |
|---|---|
| Size | 368.4 kB |
| Tags | CPython 3.13 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
3fc736fd8e1696f1844effb3cb3f76910f21bbb47d4916096ddb8482813a65ba
|
|
BLAKE2b-256 checksum How to use checksums |
31e6a09aa946d57312c6fddf138119e3a77df8fc0b84133c599d1ca725cdb462
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp312-cp312-win_amd64.whl
| Download URL | pgcopylib-0.2.3.3-cp312-cp312-win_amd64.whl |
|---|---|
| Size | 332.4 kB |
| Tags | CPython 3.12 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
7462911e88974e08b947a69f0a01d683ac8c322a6daf9e000e8db39542606eb6
|
|
BLAKE2b-256 checksum How to use checksums |
0b9b4fae7b7942096489f732beb4de2cc4df0ac634b5481d21ecc20047f57607
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 2.4 MB |
| Tags | CPython 3.12 Linux glibc 2.17+ x86-64 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
4b37c40d9cb03c9d5828895de7712cba547ff01df28187902f07dc790ea1e0aa
|
|
BLAKE2b-256 checksum How to use checksums |
f91f92b53a2b7bad87ff54994e8da2ca19d731596d6ca5616a790cc16fc06c55
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp312-cp312-macosx_11_0_arm64.whl
| Download URL | pgcopylib-0.2.3.3-cp312-cp312-macosx_11_0_arm64.whl |
|---|---|
| Size | 368.8 kB |
| Tags | CPython 3.12 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
7958b740ff931ae3b4c8bc7567587259913392442b411914ce01fc0eae621a13
|
|
BLAKE2b-256 checksum How to use checksums |
b06bb264126fad6abef26b4913adc721e74b2fb954c63c20952667881eb798ee
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp312-cp312-macosx_10_14_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp312-cp312-macosx_10_14_x86_64.whl |
|---|---|
| Size | 372.1 kB |
| Tags | CPython 3.12 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
5851820aa2091967ab3c6a927f10356f5d6924eb6b843802d9db96c50051f6f8
|
|
BLAKE2b-256 checksum How to use checksums |
4c61c5212cf8c2d691660a88a81dc67dd630f347444945caa37de24ca22de307
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp311-cp311-win_amd64.whl
| Download URL | pgcopylib-0.2.3.3-cp311-cp311-win_amd64.whl |
|---|---|
| Size | 329.7 kB |
| Tags | CPython 3.11 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
94eabd2c63c40f5a22668ce475804f4d62f1a18d701c5de632d0728837b8be58
|
|
BLAKE2b-256 checksum How to use checksums |
257999cc949953573452d5db8fdf20ec353a308a61457571a3fa27ec15d6798f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 2.3 MB |
| Tags | CPython 3.11 Linux glibc 2.17+ x86-64 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
30588d67313f395293b6a1aef5bb78f5da6f9ffc6afb80574a81a5dfbbb60351
|
|
BLAKE2b-256 checksum How to use checksums |
290bc6b20222fc74ffdd7d59cb318af3abb4221e5f2a743edb296767bb55c0e9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp311-cp311-macosx_11_0_arm64.whl
| Download URL | pgcopylib-0.2.3.3-cp311-cp311-macosx_11_0_arm64.whl |
|---|---|
| Size | 363.8 kB |
| Tags | CPython 3.11 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
ec837d96c99186bf5763c6c81f5bb11e3d27dd6ffefbbdfca2bc154e6a628d17
|
|
BLAKE2b-256 checksum How to use checksums |
b588c041fcafd1cc43418826ae040343e5c92a0ea7b7a9608b79ef447420043a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp311-cp311-macosx_10_14_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp311-cp311-macosx_10_14_x86_64.whl |
|---|---|
| Size | 368.4 kB |
| Tags | CPython 3.11 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
1c9ae66e86b13cb4d2398f5d2694dc6b12823291f293c64dc0f327baa81042b5
|
|
BLAKE2b-256 checksum How to use checksums |
b5e403c34d7dbeb1787e48c9a3f59214a3054a07e5579f3932c1c588493ae823
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp310-cp310-win_amd64.whl
| Download URL | pgcopylib-0.2.3.3-cp310-cp310-win_amd64.whl |
|---|---|
| Size | 329.7 kB |
| Tags | CPython 3.10 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
c24990484115178be36ca712c4e33876bd72526169b2670840676cc20f5bb0a7
|
|
BLAKE2b-256 checksum How to use checksums |
b55e9842fda4ecab98ddf1c0b002cc4caaa674821a7c8d8cefe5bde74d1ba6e7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl |
|---|---|
| Size | 2.1 MB |
| Tags | CPython 3.10 Linux glibc 2.17+ x86-64 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
ab881ff22767fc6a86626d657f47aea6d4b801118ad358b812c8c6c455fe17b1
|
|
BLAKE2b-256 checksum How to use checksums |
5ecf4246e08394a48073ddab52ab965fb3910cef40e048506b40f97e1d357718
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp310-cp310-macosx_11_0_arm64.whl
| Download URL | pgcopylib-0.2.3.3-cp310-cp310-macosx_11_0_arm64.whl |
|---|---|
| Size | 365.5 kB |
| Tags | CPython 3.10 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
cba58222bf37ac2c4e11236f188b58967c11cfe3bcff4773c4df1cf6031ca56a
|
|
BLAKE2b-256 checksum How to use checksums |
dbbb2c9655c0d97b249025b50fcfef4af113b029dc0a7b5547ee5e98b9c86cc5
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Release files / pgcopylib-0.2.3.3-cp310-cp310-macosx_10_14_x86_64.whl
| Download URL | pgcopylib-0.2.3.3-cp310-cp310-macosx_10_14_x86_64.whl |
|---|---|
| Size | 369.8 kB |
| Tags | CPython 3.10 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
924edd209db07008e7fd18e82ef19fbfddf2a66a5cbaa6e6056dbf9e41b7008e
|
|
BLAKE2b-256 checksum How to use checksums |
ae96fabb7be81eab873bb4a4409c6d62d27b8bd61a6410ca878b708623fbd688
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
