<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",
"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/0a/e3/cfd22fc9c49ef9dfb014693a4909c79a78748a5160f3279f1765f3a41587/dbt_postgres-1.9.1.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",
"version": "1.9.1",
"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": "d1c77eb30411f81fd299410e7a4cebc73a60b8320179d032f2efe4bd378d7bae",
"md5": "61da71564042557ac335f30af947fff4",
"sha256": "114890c53b8dff20284cf432d8130f2bbec86ce156b3a16ce6defa0b68c68d7f"
},
"downloads": -1,
"filename": "dbt_postgres-1.9.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "61da71564042557ac335f30af947fff4",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9.0",
"size": 35003,
"upload_time": "2025-09-05T18:23:36",
"upload_time_iso_8601": "2025-09-05T18:23:36.811001Z",
"url": "https://files.pythonhosted.org/packages/d1/c7/7eb30411f81fd299410e7a4cebc73a60b8320179d032f2efe4bd378d7bae/dbt_postgres-1.9.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "0ae3cfd22fc9c49ef9dfb014693a4909c79a78748a5160f3279f1765f3a41587",
"md5": "bd9223c6b7a06db3f898c53b4483cd64",
"sha256": "cf78b06c190f6fea5e8c182f3376b1ba7cd8eb0368d7c75bdac9bf8cfcd71e31"
},
"downloads": -1,
"filename": "dbt_postgres-1.9.1.tar.gz",
"has_sig": false,
"md5_digest": "bd9223c6b7a06db3f898c53b4483cd64",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9.0",
"size": 159308,
"upload_time": "2025-09-05T18:23:38",
"upload_time_iso_8601": "2025-09-05T18:23:38.714990Z",
"url": "https://files.pythonhosted.org/packages/0a/e3/cfd22fc9c49ef9dfb014693a4909c79a78748a5160f3279f1765f3a41587/dbt_postgres-1.9.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-09-05 18:23:38",
"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"
}
JSON
