--- title: Integrate PostgreSQL with CrateDB Using Foreign Data... description: CrateDB 5.7 introduces Foreign Data Wrappers (FDWs) for direct access and manipulation of data in various databases and data sources. This post explores the... canonical: https://daily.dev/posts/integrate-postgresql-with-cratedb-using-foreign-data-wrappers-pbgjwxkwv twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Integrate PostgreSQL with CrateDB Using Foreign Data Wrappers | daily.dev og:description: CrateDB 5.7 introduces Foreign Data Wrappers (FDWs) for direct access and manipulation of data in various databases and data sources. This post explores the... og:url: https://daily.dev/posts/integrate-postgresql-with-cratedb-using-foreign-data-wrappers-pbgjwxkwv og:image: https://api.daily.dev/og/posts/pBGJWXkwV.png og:image:alt: Integrate PostgreSQL with CrateDB Using Foreign Data Wrappers og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Integrate PostgreSQL with CrateDB Using Foreign Data Wrappers **[CrateDB](https://daily.dev/sources/cratedb)** · 1 min read · 2 upvotes · 0 comments ## Summary CrateDB 5.7 introduces Foreign Data Wrappers (FDWs) for direct access and manipulation of data in various databases and data sources. This post explores the integration of PostgreSQL with CrateDB using FDWs and highlights the possibilities it offers for data consolidation, cross-database joins, data access without ETL, and smoother data migrations. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#postgresql](https://daily.dev/tags/postgresql), [#cratedb](https://daily.dev/tags/cratedb) [View this post on daily.dev](https://daily.dev/posts/integrate-postgresql-with-cratedb-using-foreign-data-wrappers-pbgjwxkwv) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Integrate PostgreSQL with CrateDB Using Foreign Data Wrappers","url":"https://daily.dev/posts/integrate-postgresql-with-cratedb-using-foreign-data-wrappers-pbgjwxkwv","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/integrate-postgresql-with-cratedb-using-foreign-data-wrappers-pbgjwxkwv"},"datePublished":"2024-04-30T14:45:51.052Z","dateModified":"2024-05-09T07:52:51.999Z","description":"CrateDB 5.7 introduces Foreign Data Wrappers (FDWs) for direct access and manipulation of data in various databases and data sources. This post explores the...","image":"https://media.daily.dev/image/upload/s--foaA6JGU--/f_auto/v1722860399/public/Placeholder%2004","thumbnailUrl":"https://media.daily.dev/image/upload/s--foaA6JGU--/f_auto/v1722860399/public/Placeholder%2004","isAccessibleForFree":true,"articleSection":"CrateDB","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"CrateDB","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/46d00ffb81d0452e90976cc491162d6e","url":"https://daily.dev/sources/cratedb"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/integrate-postgresql-with-cratedb-using-foreign-data-wrappers-pbgjwxkwv","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"postgresql,cratedb","timeRequired":"PT1M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"CrateDB","item":"https://daily.dev/sources/cratedb"},{"@type":"ListItem","position":3,"name":"Integrate PostgreSQL with CrateDB Using Foreign Data Wrappers"}]} ```