<p align="center">
<img
src="https://raw.githubusercontent.com/dbt-labs/dbt/ec7dee39f793aa4f7dd3dae37282cc87664813e4/etc/dbt-logo-full.svg"
alt="dbt logo"
width="500"
/>
</p>
<p align="center">
<a href="https://pypi.org/project/dbt-postgres/">
<img src="https://badge.fury.io/py/dbt-postgres.svg" />
</a>
<a target="_blank" href="https://pypi.org/project/dbt-postgres/" style="background:none">
<img src="https://img.shields.io/pypi/pyversions/dbt-postgres">
</a>
<a href="https://github.com/psf/black">
<img src="https://img.shields.io/badge/code%20style-black-000000.svg" />
</a>
<a href="https://github.com/python/mypy">
<img src="https://www.mypy-lang.org/static/mypy_badge.svg" />
</a>
<a href="https://pepy.tech/project/dbt-postgres">
<img src="https://static.pepy.tech/badge/dbt-postgres/month" />
</a>
</p>
# dbt
**[dbt](https://www.getdbt.com/)** enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
dbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and pre-aggregate the raw data in your warehouse so that it's ready for analysis.
## dbt-postgres
`dbt-postgres` enables dbt to work with Postgres.
For more information on using dbt with Postgres, consult [the docs](https://docs.getdbt.com/docs/profile-postgres).
# Getting started
Review the repository [README.md](../README.md) as most of that information pertains to `dbt-postgres`.
### psycopg2-binary vs. psycopg2
By default, `dbt-postgres` installs `psycopg2-binary`.
This is great for development, and even testing, as it does not require any OS dependencies; it's a pre-built wheel.
However, building `psycopg2` from source will grant performance improvements that are desired in a production environment.
In order to install `psycopg2`, use the following steps:
```bash
if [[ $(pip show psycopg2-binary) ]]; then
PSYCOPG2_VERSION=$(pip show psycopg2-binary | grep Version | cut -d " " -f 2)
pip uninstall -y psycopg2-binary
pip install psycopg2==$PSYCOPG2_VERSION
fi
```
This ensures the version of `psycopg2` will match that of `psycopg2-binary`.
## Contribute
- Want to help us build `dbt-postgres`? Check out the [Contributing Guide](CONTRIBUTING.md).
Raw data
{
"_id": null,
"home_page": null,
"name": "dbt-postgres-tsw",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9.0",
"maintainer_email": "dbt Labs <info@dbtlabs.com>",
"keywords": "adapter, adapters, database, dbt, dbt Cloud, dbt Core, dbt Labs, dbt-core, elt, postgres",
"author": null,
"author_email": "dbt Labs <info@dbtlabs.com>",
"download_url": "https://files.pythonhosted.org/packages/ab/79/51c9911e079296a6c3cfce7b3489c21b704d4b7b9d305314115e65829f66/dbt_postgres_tsw-1.9.1a2.tar.gz",
"platform": null,
"description": "<p align=\"center\">\n <img\n src=\"https://raw.githubusercontent.com/dbt-labs/dbt/ec7dee39f793aa4f7dd3dae37282cc87664813e4/etc/dbt-logo-full.svg\"\n alt=\"dbt logo\"\n width=\"500\"\n />\n</p>\n\n<p align=\"center\">\n <a href=\"https://pypi.org/project/dbt-postgres/\">\n <img src=\"https://badge.fury.io/py/dbt-postgres.svg\" />\n </a>\n <a target=\"_blank\" href=\"https://pypi.org/project/dbt-postgres/\" style=\"background:none\">\n <img src=\"https://img.shields.io/pypi/pyversions/dbt-postgres\">\n </a>\n <a href=\"https://github.com/psf/black\">\n <img src=\"https://img.shields.io/badge/code%20style-black-000000.svg\" />\n </a>\n <a href=\"https://github.com/python/mypy\">\n <img src=\"https://www.mypy-lang.org/static/mypy_badge.svg\" />\n </a>\n <a href=\"https://pepy.tech/project/dbt-postgres\">\n <img src=\"https://static.pepy.tech/badge/dbt-postgres/month\" />\n </a>\n</p>\n\n# dbt\n\n**[dbt](https://www.getdbt.com/)** enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.\n\ndbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and pre-aggregate the raw data in your warehouse so that it's ready for analysis.\n\n## dbt-postgres\n\n`dbt-postgres` enables dbt to work with Postgres.\nFor more information on using dbt with Postgres, consult [the docs](https://docs.getdbt.com/docs/profile-postgres).\n\n# Getting started\n\nReview the repository [README.md](../README.md) as most of that information pertains to `dbt-postgres`.\n\n### psycopg2-binary vs. psycopg2\n\nBy default, `dbt-postgres` installs `psycopg2-binary`.\nThis is great for development, and even testing, as it does not require any OS dependencies; it's a pre-built wheel.\nHowever, building `psycopg2` from source will grant performance improvements that are desired in a production environment.\nIn order to install `psycopg2`, use the following steps:\n\n```bash\nif [[ $(pip show psycopg2-binary) ]]; then\n PSYCOPG2_VERSION=$(pip show psycopg2-binary | grep Version | cut -d \" \" -f 2)\n pip uninstall -y psycopg2-binary\n pip install psycopg2==$PSYCOPG2_VERSION\nfi\n```\n\nThis ensures the version of `psycopg2` will match that of `psycopg2-binary`.\n\n## Contribute\n\n- Want to help us build `dbt-postgres`? Check out the [Contributing Guide](CONTRIBUTING.md).\n",
"bugtrack_url": null,
"license": null,
"summary": "The set of adapter protocols and base functionality that supports integration with dbt-core, forked from dbt-labs/dbt-adapters",
"version": "1.9.1a2",
"project_urls": {
"Changelog": "https://github.com/dbt-labs/dbt-adapters/blob/main/dbt-postgres/CHANGELOG.md",
"Documentation": "https://docs.getdbt.com",
"Homepage": "https://github.com/dbt-labs/dbt-adapters/tree/main/dbt-postgres",
"Issues": "https://github.com/dbt-labs/dbt-adapters/issues",
"Repository": "https://github.com/dbt-labs/dbt-adapters.git#subdirectory=dbt-postgres"
},
"split_keywords": [
"adapter",
" adapters",
" database",
" dbt",
" dbt cloud",
" dbt core",
" dbt labs",
" dbt-core",
" elt",
" postgres"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "f7a07ffc2ee607c48480d423479d6da026c4d16b3074bf41b1279aad9ffb97a4",
"md5": "8ab9792cb664b30100bb13773b9d2aeb",
"sha256": "63098b9ddd9cbc0d09a65c8394440b70173ee72493c4862d5b5f8fca39219120"
},
"downloads": -1,
"filename": "dbt_postgres_tsw-1.9.1a2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "8ab9792cb664b30100bb13773b9d2aeb",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9.0",
"size": 35067,
"upload_time": "2025-09-03T09:26:24",
"upload_time_iso_8601": "2025-09-03T09:26:24.930439Z",
"url": "https://files.pythonhosted.org/packages/f7/a0/7ffc2ee607c48480d423479d6da026c4d16b3074bf41b1279aad9ffb97a4/dbt_postgres_tsw-1.9.1a2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "ab7951c9911e079296a6c3cfce7b3489c21b704d4b7b9d305314115e65829f66",
"md5": "20111a23c83c043f600b0407a4c27ee4",
"sha256": "d8911f3348c2ce6751648dbc5f4d676e775d69219ea0d217d2e9423f06ca4a0a"
},
"downloads": -1,
"filename": "dbt_postgres_tsw-1.9.1a2.tar.gz",
"has_sig": false,
"md5_digest": "20111a23c83c043f600b0407a4c27ee4",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9.0",
"size": 159877,
"upload_time": "2025-09-03T09:26:26",
"upload_time_iso_8601": "2025-09-03T09:26:26.258237Z",
"url": "https://files.pythonhosted.org/packages/ab/79/51c9911e079296a6c3cfce7b3489c21b704d4b7b9d305314115e65829f66/dbt_postgres_tsw-1.9.1a2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-09-03 09:26:26",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "dbt-labs",
"github_project": "dbt-adapters",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "dbt-postgres-tsw"
}
JSON
