PostgreSQL Wire Protocol with CrateDB

<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>PostgreSQL Wire Protocol with CrateDB</title> <link rel="shortcut icon" href="https://cratedb.com/hubfs/cratedb-favicon.png"> <meta name="description" content="Seamlessly integrate CrateDB with other tools via the PostgreSQL Wire Protocol for effortless adoption and enhanced workflow efficiency."> <style> .cr-header-full-height { height: 100vh; } </style>   <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103134656537/1676853350416/sf2-crate/js/jquery-3.5.1.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta property="og:description" content="Seamlessly integrate CrateDB with other tools via the PostgreSQL Wire Protocol for effortless adoption and enhanced workflow efficiency."> <meta property="og:title" content="PostgreSQL Wire Protocol with CrateDB"> <meta name="twitter:description" content="Seamlessly integrate CrateDB with other tools via the PostgreSQL Wire Protocol for effortless adoption and enhanced workflow efficiency."> <meta name="twitter:title" content="PostgreSQL Wire Protocol with CrateDB"> <style> a.cta_button{-moz-box-sizing:content-box !important;-webkit-box-sizing:content-box !important;box-sizing:content-box !important;vertical-align:middle}.hs-breadcrumb-menu{list-style-type:none;margin:0px 0px 0px 0px;padding:0px 0px 0px 0px}.hs-breadcrumb-menu-item{float:left;padding:10px 0px 10px 10px}.hs-breadcrumb-menu-divider:before{content:'›';padding-left:10px}.hs-featured-image-link{border:0}.hs-featured-image{float:right;margin:0 0 20px 20px;max-width:50%}@media (max-width: 568px){.hs-featured-image{float:none;margin:0;width:100%;max-width:100%}}.hs-screen-reader-text{clip:rect(1px, 1px, 1px, 1px);height:1px;overflow:hidden;position:absolute !important;width:1px} </style> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52693799430/1721897980656/sf2-crate/css/main.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hubfs/hub_generated/template_assets/1/52694827330/1738848507412/template_theme-overrides.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/55523967869/1722426745670/module_55523967869_Header_Notif_Bar.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52694764069/1701097527939/module_52694764069_menu-section.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/124127418129/1716804134819/module_124127418129_Related_Content_23.min.css">  <style id="hs_editor_style" type="text/css"> #hs_cos_wrapper_widget_1693987516219 { display: block !important; padding-bottom: 20px !important; padding-top: 20px !important } #hs_cos_wrapper_widget_1693987516219 { display: block !important; padding-bottom: 20px !important; padding-top: 20px !important } .dnd_area-row-0-force-full-width-section > .row-fluid { max-width: none !important; } .dnd_area-row-1-max-width-section-centering > .row-fluid { max-width: 1240px !important; margin-left: auto !important; margin-right: auto !important; } .widget_1693987516219-flexbox-positioning { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-align: center !important; -ms-flex-pack: start; display: flex !important; flex-direction: column !important; align-items: center !important; justify-content: flex-start; } .widget_1693987516219-flexbox-positioning > div { max-width: 100%; flex-shrink: 0 !important; } /* HubSpot Styles (default) */ .dnd_area-row-0-background-layers { background-image: url('https://cratedb.com/hubfs/cr-header-mesh.jpg') !important; background-position: center center !important; background-size: cover !important; background-repeat: no-repeat !important; } .dnd_area-row-1-padding { padding-top: 40px !important; padding-bottom: 0px !important; } .dnd_area-row-2-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-2-background-layers { background-image: linear-gradient(rgba(243, 243, 243, 1), rgba(243, 243, 243, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-3-padding { padding-bottom: 0px !important; } .dnd_area-row-4-background-layers { background-image: linear-gradient(rgba(246, 246, 246, 1), rgba(246, 246, 246, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } </style>  <script> var _hsp = window._hsp = window._hsp || []; window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} var useGoogleConsentModeV2 = true; var waitForUpdateMillis = 1000; if (!window._hsGoogleConsentRunOnce) { window._hsGoogleConsentRunOnce = true; gtag('consent', 'default', { 'ad_storage': 'denied', 'analytics_storage': 'denied', 'ad_user_data': 'denied', 'ad_personalization': 'denied', 'wait_for_update': waitForUpdateMillis }); if (useGoogleConsentModeV2) { _hsp.push(['useGoogleConsentModeV2']) } else { _hsp.push(['addPrivacyConsentListener', function(consent){ var hasAnalyticsConsent = consent && (consent.allowed || (consent.categories && consent.categories.analytics)); var hasAdsConsent = consent && (consent.allowed || (consent.categories && consent.categories.advertisement)); gtag('consent', 'update', { 'ad_storage': hasAdsConsent ? 'granted' : 'denied', 'analytics_storage': hasAnalyticsConsent ? 'granted' : 'denied', 'ad_user_data': hasAdsConsent ? 'granted' : 'denied', 'ad_personalization': hasAdsConsent ? 'granted' : 'denied' }); }]); } } gtag('js', new Date()); gtag('set', 'developer_id.dZTQ1Zm', true); gtag('config', 'G-6J80J11VFJ'); </script> <script async src="https://www.googletagmanager.com/gtag/js?id=G-6J80J11VFJ"></script>   <script> var _hsp = window._hsp = window._hsp || []; window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} var useGoogleConsentModeV2 = true; var waitForUpdateMillis = 1000; var hsLoadGtm = function loadGtm() { if(window._hsGtmLoadOnce) { return; } if (useGoogleConsentModeV2) { gtag('set','developer_id.dZTQ1Zm',true); gtag('consent', 'default', { 'ad_storage': 'denied', 'analytics_storage': 'denied', 'ad_user_data': 'denied', 'ad_personalization': 'denied', 'wait_for_update': waitForUpdateMillis }); _hsp.push(['useGoogleConsentModeV2']) } (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-WHMDSK'); window._hsGtmLoadOnce = true; }; _hsp.push(['addPrivacyConsentListener', function(consent){ if(consent.allowed || (consent.categories && consent.categories.analytics)){ hsLoadGtm(); } }]); </script>  <link rel="canonical" href="https://cratedb.com/product/features/postgresql-wire-protocol"> <meta property="og:url" content="https://cratedb.com/product/features/postgresql-wire-protocol"> <meta name="twitter:card" content="summary"> <meta http-equiv="content-language" content="en">    <meta property="og:image" content="https://cratedb.com/hubfs/cr-featured-image-23.jpg"> <meta property="og:image:width" content="1200"> <meta property="og:image:height" content="630"> <meta property="og:image:alt" content="CrateDB - Data Insights at Scale"> <meta name="generator" content="HubSpot"></head> <body class="">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-WHMDSK" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="body-wrapper hs-content-id-133508126472 hs-site-page page "> <div id="hs_cos_wrapper_Header_Notif_Bar" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"></div> <div data-global-resource-path="sf2-crate/templates/partials/header-landify.html"> <header class="header" style="color: #ffffff ;" id="top"> <a href="#main-content" class="header__skip">Skip to content</a> <div class="header__container content-wrapper"> <div class="header__logo header__logo--main"> <div id="hs_cos_wrapper_site_logo" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-logo" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <span id="hs_cos_wrapper_site_logo_hs_logo_widget" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_logo" style="" data-hs-cos-general-type="widget" data-hs-cos-type="logo"><a href="/" id="hs-link-site_logo_hs_logo_widget" style="border-width:0px;border:0px;"><img src="https://cratedb.com/hubfs/CrateDB-logo-blue-white.svg" class="hs-image-widget " height="204" style="height: auto;width:1433px;border-width:0px;border:0px;" width="1433" alt="CrateDB logo" title="CrateDB logo" loading="eager"></a></span> </div> </div> <div class="header_nav_column" style="text-align: center ;"> <div class="header_nav"> <div class="header--toggle header__navigation--toggle"></div> <div class="header__close--toggle"></div> <div class="header__navigation header--element"> <div id="hs_cos_wrapper_navigation-primary" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <nav aria-label="Main menu" class="navigation-primary"> <ul class="submenu level-1"> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Product">Product</a> <ul class="submenu level-2"> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Database">Database</a> <ul class="submenu level-3"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database" class="menu-link" title="Overview">Overview</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/sql-examples" class="menu-link" title="SQL examples">SQL examples</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/integrations" class="menu-link" title="Integrations">Integrations</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/security" class="menu-link" title="Security">Security</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Data models">Data models</a> <ul class="submenu level-3"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/time-series" class="menu-link" title="Time-series">Time-series</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/json" class="menu-link" title="Document/JSON">Document/JSON</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/vector" class="menu-link" title="Vector">Vector</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/full-text" class="menu-link" title="Full-text">Full-text</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/geospatial" class="menu-link" title="Spatial">Spatial</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/relational" class="menu-link" title="Relational">Relational</a> </li> </ul> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Use cases">Use cases</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/real-time-analytics-database" class="menu-link" title="Real-time analytics">Real-time analytics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/hybrid-search" class="menu-link" title="Hybrid search">Hybrid search</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/ai-ml-database" class="menu-link" title="AI/ML integration">AI/ML integration</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/chatbots" class="menu-link" title="AI-powered chatbots">AI-powered chatbots</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/iot-database" class="menu-link" title="Internet of Things">Internet of Things</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/geospatial-analytics" class="menu-link" title="Geospatial analytics">Geospatial analytics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/log-database" class="menu-link" title="Log & event analysis">Log & event analysis</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Industries">Industries</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/energy" class="menu-link" title="Energy">Energy</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/financial-services" class="menu-link" title="Financial Services">Financial Services</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/fmcg" class="menu-link" title="FMCG">FMCG</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/logistics" class="menu-link" title="Logistics">Logistics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/manufacturing" class="menu-link" title="Manufacturing">Manufacturing</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/oil-gas-mining" class="menu-link" title="Oil, gas & mining">Oil, gas & mining</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/smart-cities" class="menu-link" title="Smart city solutions">Smart city solutions</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/tech-platforms" class="menu-link" title="Technology platforms">Technology platforms</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/telco" class="menu-link" title="Telco">Telco</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/transportation" class="menu-link" title="Transportation">Transportation</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Resources">Resources</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/stories" class="menu-link" title="Customer stories">Customer stories</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/academy" class="menu-link" title="Academy">Academy</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/library" class="menu-link" title="Asset library">Asset library</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/blog" class="menu-link" title="Blog">Blog</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/event" class="menu-link" title="Events">Events</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Developer">Developer</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="/docs/guide/home/" class="menu-link" title="Documentation">Documentation</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/drivers-tools" class="menu-link" title="Drivers and tools">Drivers and tools</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/community" class="menu-link" title="Community">Community</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://github.com/crate/crate/" class="menu-link" target="_blank" rel="noopener" title="GitHub">GitHub</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/support" class="menu-link" title="Support">Support</a> </li> </ul> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/pricing" class="menu-link" title="Pricing">Pricing</a> </li> </ul> </nav></div> <div class="header__cta__column mb"> <div class="header__cta"> <div id="hs_cos_wrapper_module_161720035400929" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="ly-cta-div header-icons"> <div class="cr-gh-header"> <a href="https://github.com/crate/" title="Follow CrateDB on GitHub" rel="noreferrer" target="_blank"> <svg version="1.0" height="20" width="20" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="github5" role="img"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg> </a> </div> <div class="cr-gh-header cr-search-header"> <a href="/search" class="search-btn menu-link" title="Search on cratedb.com"> <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewbox="0 0 512 512"><path d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376c-34.4 25.2-76.8 40-122.7 40C93.1 416 0 322.9 0 208S93.1 0 208 0S416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg> </a> </div> </div> <div class="ly-cta-div" style="margin-right:0;"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="140734001567"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLN26yv8kQRp2WAoeOu9bNBbkLvTvRFUszq%2FYx5PHh5KDMckqiVw13YriNZl%2FdwfLQhIBdngdVl9Lx2IjudAdjrNLPdfhOwxbALtLSGiVSiJme4GD1HjmmjV%2BLWcWF9BI7hRc97dyKGXNt5JHxSRJoHlvLASH5kuFKzd92WI2YJWJb%2BFVwL%2FkowhjQ7LStla2KXRfev%2Bt5hHZ6w0AIdYbL%2Bw5TrWqqtyhZwdCt8vhgIqhu3f3Em59QiBrX4OknB3IvxW9zy0KkmILmwktRj%2BbA%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-140734001567 cta-btn login-cta menu-link " data-hubspot-cta-id="140734001567"> Log In </a> </div> </div> <div class="ly-cta-div"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178336831256"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIJe21Dd%2BqMBXuwhUEwIxeKvQRteMuuvBgS0cjHs7WtGTrDP%2FOCVzg%2F92IOl9VbWfNtTIu%2FKC6mz8pqjKES7LqJM2rA5K6VXfMhvFaG4WQW2LFPe9AVNyYpYDsMuKe%2FlqIfbRifuiV29ECfFn%2BRra2Unad4SCh6ECtacrskeaY%2FWA%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178336831256 cr-btn-div cr-btn-2 " data-hubspot-cta-id="178336831256"> Start free </a> </div> </div> <style> .ly-cta-div a.cta-btn.login-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn.signup-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn{ display:inline-block; position:relative; padding:10px 25px; font-family:sans-serif; transition: all .4s ease; line-height:21px; border-radius:5px; cursor:pointer; text-decoration:none; font-weight: 600; } .ly-cta-div a.cta-btn:hover{ opacity:.7; } .cr-gh-header.cr-search-header { padding: 0; margin-right: 0; } div#hs_cos_wrapper_module_161720035400929 { display: inline-block; } </style></div> </div> </div> </div> </div> </div> <div class="header__cta__column lg"> <div class="header__cta"> <div id="hs_cos_wrapper_module_161720035400929" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="ly-cta-div header-icons"> <div class="cr-gh-header"> <a href="https://github.com/crate/" title="Follow CrateDB on GitHub" rel="noreferrer" target="_blank"> <svg version="1.0" height="20" width="20" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="github5" role="img"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg> </a> </div> <div class="cr-gh-header cr-search-header"> <a href="/search" class="search-btn menu-link" title="Search on cratedb.com"> <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewbox="0 0 512 512"><path d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376c-34.4 25.2-76.8 40-122.7 40C93.1 416 0 322.9 0 208S93.1 0 208 0S416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg> </a> </div> </div> <div class="ly-cta-div" style="margin-right:0;"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="140734001567"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLN26yv8kQRp2WAoeOu9bNBbkLvTvRFUszq%2FYx5PHh5KDMckqiVw13YriNZl%2FdwfLQhIBdngdVl9Lx2IjudAdjrNLPdfhOwxbALtLSGiVSiJme4GD1HjmmjV%2BLWcWF9BI7hRc97dyKGXNt5JHxSRJoHlvLASH5kuFKzd92WI2YJWJb%2BFVwL%2FkowhjQ7LStla2KXRfev%2Bt5hHZ6w0AIdYbL%2Bw5TrWqqtyhZwdCt8vhgIqhu3f3Em59QiBrX4OknB3IvxW9zy0KkmILmwktRj%2BbA%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-140734001567 cta-btn login-cta menu-link " data-hubspot-cta-id="140734001567"> Log In </a> </div> </div> <div class="ly-cta-div"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178336831256"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIJe21Dd%2BqMBXuwhUEwIxeKvQRteMuuvBgS0cjHs7WtGTrDP%2FOCVzg%2F92IOl9VbWfNtTIu%2FKC6mz8pqjKES7LqJM2rA5K6VXfMhvFaG4WQW2LFPe9AVNyYpYDsMuKe%2FlqIfbRifuiV29ECfFn%2BRra2Unad4SCh6ECtacrskeaY%2FWA%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178336831256 cr-btn-div cr-btn-2 " data-hubspot-cta-id="178336831256"> Start free </a> </div> </div> <style> .ly-cta-div a.cta-btn.login-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn.signup-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn{ display:inline-block; position:relative; padding:10px 25px; font-family:sans-serif; transition: all .4s ease; line-height:21px; border-radius:5px; cursor:pointer; text-decoration:none; font-weight: 600; } .ly-cta-div a.cta-btn:hover{ opacity:.7; } .cr-gh-header.cr-search-header { padding: 0; margin-right: 0; } div#hs_cos_wrapper_module_161720035400929 { display: inline-block; } </style></div> </div> </div> </div> </header></div> <main id="main-content" class="body-container-wrapper"> <div class="container-fluid body-container body-container--about"> <div class="row-fluid-wrapper"> <div class="row-fluid"> <div class="span12 widget-span widget-type-cell " style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-1 dnd_area-row-0-force-full-width-section dnd_area-row-0-background-layers dnd-section dnd_area-row-0-background-image"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-2 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16901864227893" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="cr-clusters-items-wrapper cr-clusters-limit" id="module_16901864227893"> <style> #module_16901864227893.cr-clusters-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16901864227893.cr-clusters-items-wrapper.cr-clusters-limit, .cr-meta-inner { max-width: 1200px; } #module_16901864227893 .cr-clusters-container.cr-customers-header-sub { max-width: 1200px; margin: 0 auto; } #module_16901864227893 .cr-clusters-container { display: flex; align-items: center; } #module_16901864227893 .cr-clusters-header { margin-bottom: 20px; display: flex; align-items: baseline; } #module_16901864227893 .cr-clusters-header h1 { letter-spacing: -2.04px; max-width: 620px; margin-right: 20px; margin-bottom: 0px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.2; } #module_16901864227893 .cr-customers-header-sub .cr-clusters-header h1 { max-width: 980px; } #module_16901864227893 .cr-customers-header-sub .cr-clusters-limit-width-headline.cr-clusters-header h1 { max-width: 700px; } #module_16901864227893.cr-clusters-limit .cr-customers-header-sub .cr-clusters-introtext { max-width: 950px; } #module_16901864227893:not(.cr-clusters-limit) .cr-customers-header-sub .cr-clusters-introtext { max-width: 100%; } #module_16901864227893 .cr-clusters-image { flex: 3; } #module_16901864227893 .cr-clusters-image img { height: auto; } #module_16901864227893 .cr-clusters-introtext, #module_16901864227893 .cr-clusters-introtext p, #module_16901864227893 .cr-clusters-introtext span { color: rgba(255, 255, 255, 1.0); font-size: 21px; margin-right: 100px; } #module_16901864227893 .cr-clusters-introtext { max-width: 680px; } #module_16901864227893 .cr-clusters-left { padding-top: 60px; flex: 3; } #module_16901864227893 .cr-header-section { display: block; font-size: 20px; font-weight: 600; color: #19C0EA; } #module_16901864227893 .cr-clusters-arrow { align-self: flex-end; } #module_16901864227893 .cr-clusters-arrow svg { max-width: 40px; height: auto; } .cr-landingpage-header { margin-bottom: 78px; } .cr-landingpage-header .dnd-column { padding: 0; } .cr-header-meta-bar { background: rgb(8, 29, 36); opacity: 1; padding: 20px 20px; position: absolute; bottom: -146px; left: 0; right: 0; margin-left: -20px; margin-right: -20px; } .cr-header-meta-bar > div > div { display: flex; font-family: Inter; font-weight: 600; font-size: 16px; line-height: 20px; letter-spacing: 0px; color: #FFFFFF; opacity: 1; } .cr-meta-inner { display: flex; flex-direction: row; align-items: center; justify-content: flex-start; margin: 0 auto; } .cr-meta-item { display: flex; align-items: center; margin-right: 30px; } .cr-meta-item img { margin-right: 10px; } .cr-header-speaker-image img { border-radius: 50%; max-width: 80px !important; } .cr-header-speaker-name { letter-spacing: -0.56px; color: #FFFFFF; font-size: 18px; line-height: 24px; font-weight: bold; font-family: Inter; text-align: center; margin-bottom: 2px; } .cr-header-speakers { display: flex; flex-direction: row; margin-top: 80px; } .cr-header-speakers-item:last-child { margin-left: 50px; } .cr-header-speaker-title { letter-spacing: -0.36px; color: #e3b15b; font-size: 16px; line-height: 20px; font-family: Inter; font-weight: 500; text-align: center; } .cr-header-speaker-image { text-align: center; } .cr-header-multipurpose { position: relative; } /*@media all and (min-width: 1200px) { .cr-header-speaker-image img { max-width: 100% !important; } }*/ @media all and (max-width: 1200px) { } @media all and (max-width: 980px) { #module_16901864227893 .cr-clusters-container { flex-direction: column; } #module_16901864227893 .cr-clusters-introtext { font-size: 18px; } #module_16901864227893 .cr-clusters-header h1 { width: auto; max-width: 100%; } #module_16901864227893 .cr-clusters-container { align-items: flex-start; } } @media all and (max-width: 767px) { #module_16901864227893 .cr-clusters-introtext { margin-right: 0; } .cr-header-meta-bar > div > div { flex-direction: column; text-align: center; font-size: 14px; } .cr-meta-item { margin-right: 10px; } .cr-header-speakers { margin-top: 40px; } } </style> <div class="cr-clusters-container cr-customers-header-sub"> <div class="cr-clusters-left"> <span class="cr-header-section">Features</span> <div class="cr-clusters-header "> <h1 style="color: rgba(255, 255, 255, 1.0);">PostgreSQL Wire Protocol</h1> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-3 dnd_area-row-1-padding dnd_area-row-1-max-width-section-centering dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-4 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_1629984372571" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_module_1629984372571_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text">The <strong>PostgreSQL wire protocol</strong> is a binary protocol used to facilitate communication between a PostgreSQL client and server.  <br><br>The benefit of using the PostgreSQL wire protocol in CrateDB lies in its seamless compatibility with various SQL tools. By adopting this protocol, CrateDB becomes easily onboardable and works with most SQL tools, such as JDBC, ODBC, and REST interfaces. This ensures that users can effortlessly integrate their existing tools and applications, streamlining the adoption of CrateDB within their workflows. <br><br>See the sample list of <a href="/integrations" rel="noopener">third-party integrations ></a></span></div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-5 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget widget_1693987516219-flexbox-positioning dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1693987516219" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-linked_image" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <span id="hs_cos_wrapper_widget_1693987516219_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_linked_image" style="" data-hs-cos-general-type="widget" data-hs-cos-type="linked_image"><a href="/integrations" target="_parent" id="hs-link-widget_1693987516219_" style="border-width:0px;border:0px;"><img src="https://crate.io/hubfs/CrateDB-PostgreSQL.jpg" class="hs-image-widget " width="750" height="304" style="max-width: 100%; height: auto;" alt="CrateDB-PostgreSQL" title="CrateDB-PostgreSQL" loading="lazy"></a></span></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-6 dnd_area-row-2-background-layers dnd_area-row-2-padding dnd_area-row-2-background-color dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-7 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16939863727204" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_16939863727204 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; margin-bottom: 0px !important; margin-top: 0px !important; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; margin-bottom: 0px !important; margin-top: 0px !important; } @media all and (max-width: 767px) { #module_16939863727204 h2.cr-headline { font-size: 20px; margin-bottom: 20px; margin-bottom: 0px !important; margin-top: 0px !important; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="module_16939863727204" class="cr-headline" style="">Product documentation</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-8 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16939863727205" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-featuresbox-items-wrapper" id="module_16939863727205"> <style> #module_16939863727205.cr-featuresbox-items-wrapper { /*max-width: 1760px;*/ margin-bottom: 40px; } #module_16939863727205 .cr-featuresbox-container { background: #fff; margin: 30px auto 20px; position: relative; padding: 30px 40px 30px 40px; box-shadow: 0px 8px 22px #0000001C; border: 1px solid #FFFFFF1C; overflow: hidden; transition: box-shadow 0.3s ease-in-out; } #module_16939863727205 .cr-featuresbox-headline { padding-right: 30px; } #module_16939863727205 .cr-featuresbox-headline h3 { font-size: 28px; font-weight: bold; letter-spacing: -0.64px; margin-top: 0; margin-bottom: 16px; } #module_16939863727205 .cr-featuresbox-icon img { max-width: 24px !important; position: absolute; /*right: 20px;*/ right: 10px; /*bottom: -24px;*/ top: 10px; opacity: .2; } #module_16939863727205 .cr-featuresbox-link { position: absolute; top: 0; right: 0; bottom: 0; left: 0; display: block; z-index: 9; display: flex; justify-content: space-between; align-items: center; } #module_16939863727205 .cr-featuresbox-link svg { max-width: 30px; height: auto; margin-right: 24px; position: absolute; right: 0px; z-index: -1; } #module_16939863727205 .cr-featuresbox-link a, #module_16939863727205 .cr-featuresbox-link a:visited { width: 100%; height: 100%; display: block; text-decoration: none; } #module_16939863727205 .cr-featuresbox-link a:hover, #module_16939863727205 .cr-featuresbox-link a:active { text-decoration: none; } #module_16939863727205 .cr-featuresbox-text { font-size: 16px; padding-right: 120px; } #module_16939863727205 .cr-featuresbox-readmore { text-align: right; margin-top: 40px; } #module_16939863727205 .cr-featuresbox-readmore svg { max-width: 22px; height: auto; margin-left: 5px; } #module_16939863727205 .cr-featuresbox-container p:last-child { margin-bottom: 0; } #module_16939863727205 .cr-featuresbox-readmore a { font-size: 18px; color: #19C0EA; text-decoration: none; font-weight: bold; display: flex; justify-content: flex-end; align-items: center; } @media all and (max-width: 767px) { #module_16939863727205 .cr-featuresbox-container { padding: 20px 30px 20px 30px; } #module_16939863727205 .cr-featuresbox-text { padding-right: 0px; } #module_16939863727205 .cr-featuresbox-link { align-items: flex-start; } #module_16939863727205 .cr-featuresbox-headline { padding-right: 0px; } #module_16939863727205 .cr-featuresbox-link svg { margin-top: 24px; } #module_16939863727205 .cr-featuresbox-headline h3 { font-size: 22px; padding-right: 30px; } } </style> <style> #module_16939863727205 .cr-featuresbox-container:hover { box-shadow: 0px 8px 22px #00000038; } </style> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3 style="margin-bottom: 0;">PostgreSQL wire protocol</h3> </div> <div class="cr-featuresbox-link"> <a href="/docs/crate/reference/en/latest/interfaces/postgres.html#server-compatibility" target="_blank" rel="noopener">  </a> <svg xmlns="http://www.w3.org/2000/svg" width="69.969" height="56.814" viewbox="0 0 69.969 56.814"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="Path_42" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8" /> <line id="Line_1" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8" /> </g> </g> </svg> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-9 dnd-section dnd_area-row-3-padding"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-10 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1691572710618" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #widget_1691572710618 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; } @media all and (max-width: 767px) { #widget_1691572710618 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="widget_1691572710618" class="cr-headline" style="">Additional resources</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-11 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1693220504043" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #widget_1693220504043{ } #widget_1693220504043 h1 { color: ; } </style> <div class="cr-relatedcontent" id="widget_1693220504043"> <div class="content-wrapper"> <div class="cr-relatedcontent-cards"> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Tutorial</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://community.crate.io/t/connecting-with-ssl-to-cratedb-using-the-postgresql-protocol-from-java-based-applications/1591" target="_blank" rel="noopener"> Connecting with SSL to CrateDB using the PostgreSQL protocol from Java-based applications</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_widget_1693220504043_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Tutorial</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://community.crate.io/t/migrating-from-postgresql-or-timescale-to-cratedb/620" target="_blank" rel="noopener"> Migrating from PostgreSQL or Timescale to CrateDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_widget_1693220504043_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content">This article describes how to migrate tables from PostgreSQL (using the TimescaleDB extension) to CrateDB.</div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Tutorials</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://community.crate.io/t/overview-of-cratedb-integration-tutorials/1015" target="_blank" rel="noopener"> Overview of CrateDB integration tutorials</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_widget_1693220504043_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content">We’ve created many integration-focused tutorials to help you use CrateDB with other awesome tools and libraries.</div> </div> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-12 dnd-section dnd_area-row-4-background-layers dnd_area-row-4-background-color"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-13 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16932226417395" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-getstarted-items-wrapper" id="module_16932226417395"> <style> #module_16932226417395.cr-getstarted-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16932226417395 .cr-getstarted-header { margin-bottom: 32px; display: flex; align-items: center; margin-right: 20px; } #module_16932226417395 .cr-getstarted-item { margin-right: 20px; } #module_16932226417395 .cr-getstarted-items { display: flex; flex-direction: row; } #module_16932226417395 .cr-getstarted-header h2 { letter-spacing: -2.04px; color: #0A2327; margin-right: 30px; margin-bottom: 0; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; } #module_16932226417395 .cr-getstarted-header svg { height: 50px; width: auto; } #module_16932226417395 .cr-getstarted-container.cr-gestarted-inline { display: flex; align-items: center; /*justify-content: space-between;*/ } #module_16932226417395 .cr-gestarted-inline .cr-getstarted-header, #module_16932226417395 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 0px; } @media all and (max-width: 767px) { #module_16932226417395 .cr-getstarted-container.cr-gestarted-inline { display: block; } #module_16932226417395 .cr-gestarted-inline .cr-getstarted-header { margin-bottom: 20px; } #module_16932226417395 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 12px; } #module_16932226417395 .cr-getstarted-header svg { height: 30px; margin-bottom: 12px; } } </style> <div class="cr-getstarted-container cr-gestarted-inline"> <div class="cr-getstarted-header"> <h2>Interested in learning more?</h2> </div> <div class="cr-getstarted-items"> <div class="cr-getstarted-item"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="136730818150"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLj2PyuSfHUutb5Ljq1DrqFoNmVFmMNxULJcUAE7CRP8ZG25teP65Z34arL7mr1okJJlu0ewG4xIDTsggpWWVJlkkKDWIiwrSiimt6YF1wZaQcDzh%2B3Cn2aPcgT7PfUKnz583TSBDehGOdKzW3tesCAoEbRRBUb85dQmQm8Fg%3D%3D&portalId=19927462" class="hs-inline-web-interactive-136730818150 hs-button " data-hubspot-cta-id="136730818150"> Contact us </a> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <input type="hidden" name="breadcrumb" value=""> </main> <div data-global-resource-path="sf2-crate/templates/partials/footer-landify.html"> <footer class="footer" id="cr-footer"> <div class="footer-overlay-color" style="background-color: transparent;"> <div class="footer__container content-wrapper footer_firstrow"> <div class="row-fluid"> <div class="span12"> <div class="row-fluid footer-widget"> <div class="span3 footer-widget-content"> <div class="footer_logo"> <img src="https://cratedb.com/hubfs/19927462/CrateDB-logo-blue-white.svg" class="hs-image-widget" loading="lazy" style="width:154px;border-width:0px;border:0px;" alt="CrateDB Logo" title="White CrateDB Logo" width="154" height="22"> </div> <div class="footer__social"> <div id="hs_cos_wrapper_footer_social" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> .social-links { -webkit-box-align: center; -ms-flex-align: center; align-items: center; display: -webkit-box; display: -ms-flexbox; display: flex; -ms-flex-wrap: wrap; flex-wrap: wrap; -webkit-box-pack: center; -ms-flex-pack: center; justify-content: center; } .social-links__icon { background-color: #494A52; border-radius: 50%; display: -webkit-inline-box; display: -ms-inline-flexbox; display: inline-flex; height: 40px; margin: 0 5px; position: relative; width: 40px; } .social-links__icon:hover, .social-links__icon:focus { background-color: #21222A; } .social-links__icon:active { background-color: #71727A; } .social-links__icon svg { fill: #FFF; height: 15px; left: 50%; position: absolute; top: 50%; -webkit-transform: translate(-50%, -50%); -ms-transform: translate(-50%, -50%); transform: translate(-50%, -50%); width: auto; } .social-links__icon:hover svg, .social-links__icon:focus svg, .social-links__icon:active svg { fill: #FFF; } /* Overrides 2021 -j */ .social-links__icon { height: 25px; width: 25px; margin: 0 8px; } </style> <div class="social-links"> <a class="social-links__link nav-link" href="https://twitter.com/cratedb" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" aria-labelledby="X Twitter1" role="img"><title id="X Twitter1">Follow us on Twitter</title><g id="X Twitter1_layer"><path d="M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z" /></g></svg></span> <span class="injected hidden">Follow us on Twitter</span> </a> <a class="social-links__link nav-link" href="https://www.linkedin.com/company/crateio/" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__2" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 448 512" aria-labelledby="LinkedIn In2" role="img"><title id="LinkedIn In2">Follow us on GitHub</title><g id="LinkedIn In2_layer"><path d="M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z" /></g></svg></span> <span class="injected hidden">Follow us on GitHub</span> </a> <a class="social-links__link nav-link" href="https://www.youtube.com/@CrateDB" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__3" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 576 512" aria-labelledby="YouTube3" role="img"><title id="YouTube3">Follow us on YouTube</title><g id="YouTube3_layer"><path d="M549.655 124.083c-6.281-23.65-24.787-42.276-48.284-48.597C458.781 64 288 64 288 64S117.22 64 74.629 75.486c-23.497 6.322-42.003 24.947-48.284 48.597-11.412 42.867-11.412 132.305-11.412 132.305s0 89.438 11.412 132.305c6.281 23.65 24.787 41.5 48.284 47.821C117.22 448 288 448 288 448s170.78 0 213.371-11.486c23.497-6.321 42.003-24.171 48.284-47.821 11.412-42.867 11.412-132.305 11.412-132.305s0-89.438-11.412-132.305zm-317.51 213.508V175.185l142.739 81.205-142.739 81.201z" /></g></svg></span> <span class="injected hidden">Follow us on YouTube</span> </a> <a class="social-links__link nav-link" href="https://github.com/crate/crate" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__4" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="GitHub4" role="img"><title id="GitHub4">Follow us on GitHub</title><g id="GitHub4_layer"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z" /></g></svg></span> <span class="injected hidden">Follow us on GitHub</span> </a> </div></div> </div> </div> <div id="hs_cos_wrapper_module_16142721378942" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Company </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_1.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/company/leadership" rel="noopener">Leadership</a></li> <li><a class="nav-link" href="https://cratedb.com/company/team" rel="noopener">Team</a></li> <li><a class="nav-link" href="https://cratedb.com/company/investors" rel="noopener">Investors</a></li> <li><a class="nav-link" href="https://cratedb.com/company/career" rel="noopener">Career</a></li> <li><a class="nav-link" href="https://cratedb.com/event" rel="noopener">Events</a></li> <li><a class="nav-link" href="https://cratedb.com/press" rel="noopener">Newsroom</a></li> <li><a class="nav-link" href="https://cratedb.com/company/media-kit" rel="noopener">Media kit</a></li> </ul></div> </div> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Ecosystem </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_2.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/partners" rel="noopener">Partners</a></li> <li><a class="nav-link" href="https://cratedb.com/product/editions/startups" rel="noopener">Startups</a></li> <li><a class="nav-link" href="https://cratedb.com/integrations" rel="noopener">Integrations</a></li> </ul></div> </div> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Contact </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_3.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/contact" rel="noopener">Contact us</a></li> <li><a class="nav-link" href="https://cratedb.com/contact/offices" rel="noopener">Offices</a></li> <li><a class="nav-link" href="https://cratedb.com/database/security#contact" rel="noopener">Security</a></li> <li><a class="nav-link" href="https://cratedb.com/support" rel="noopener">Support</a></li> </ul></div> </div> </div> </div> </div> </div> </div> </div> <div class="footer-second-row-overlay" style="background-color: transparent;"> <div class="footer__container content-wrapper footer_copyright"> <div class="footer__copyright"> <div id="hs_cos_wrapper_footer_copyright_text" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_footer_copyright_text_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="text">© 2024 CrateDB. All rights reserved.</span></div> </div> <div class="hs_cos_wrapper_widget"> <ul> <li> | </li> <li><a href="/legal" class="nav-link">Legal</a> | </li> <li><a href="/legal/privacy-policy" class="nav-link">Privacy Policy</a> | </li> <li><a href="/legal/imprint" class="nav-link">Imprint</a></li> </ul> </div> </div> </div> </footer> </div> </div>  <script defer src="/hs/hsstatic/content-cwv-embed/static-1.1293/embed.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52694035002/1710167292109/sf2-crate/js/main.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103135878028/1676853638526/sf2-crate/js/prism-core.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103135878026/1676853638465/sf2-crate/js/prism-autoloader.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/53645044755/1688038947921/sf2-crate/js/prism.min.js"></script> <script> var hsVars = hsVars || {}; hsVars['language'] = 'en'; </script> <script src="/hs/hsstatic/cos-i18n/static-1.53/bundles/project.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52694764069/1701097527096/module_52694764069_menu-section.min.js"></script>  <script defer src="https://js.hubspot.com/web-interactives-embed.js" type="text/javascript" id="hubspot-web-interactives-loader" data-loader="hs-previewer" data-hsjs-portal="19927462" data-hsjs-env="prod" data-hsjs-hublet="na1"></script>   <script type="text/javascript"> var _hsq = _hsq || []; _hsq.push(["setContentType", "standard-page"]); _hsq.push(["setCanonicalUrl", "https:\/\/cratedb.com\/product\/features\/postgresql-wire-protocol"]); _hsq.push(["setPageId", "133508126472"]); _hsq.push(["setContentMetadata", { "contentPageId": 133508126472, "legacyPageId": "133508126472", "contentFolderId": null, "contentGroupId": null, "abTestId": null, "languageVariantId": 133508126472, "languageCode": "en", }]); </script> <script type="text/javascript" id="hs-script-loader" async defer src="/hs/scriptloader/19927462.js"></script>  <script type="text/javascript"> var hsVars = { render_id: "9843b219-d52b-4d55-8178-5cbc9c88b54a", ticks: 1739074690636, page_id: 133508126472, content_group_id: 0, portal_id: 19927462, app_hs_base_url: "https://app.hubspot.com", cp_hs_base_url: "https://cp.hubspot.com", language: "en", analytics_page_type: "standard-page", scp_content_type: "", analytics_page_id: "133508126472", category_id: 1, folder_id: 0, is_hubspot_user: false } </script> <script defer src="/hs/hsstatic/HubspotToolsMenu/static-1.393/js/index.js"></script> <script type="text/javascript"> // Log the analytics category consent status of the current visitor to the console var _hsp = window._hsp = window._hsp || []; // analytics _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.analytics == true) { //console.log("analytics cookies enabled"); /* clarity */ (function(c,l,a,r,i,t,y){ c[a]=c[a]||function(){(c[a].q=c[a].q||[]).push(arguments)}; t=l.createElement(r);t.async=1;t.src="https://www.clarity.ms/tag/"+i; y=l.getElementsByTagName(r)[0];y.parentNode.insertBefore(t,y); })(window, document, "clarity", "script", "dyojgmowl8"); } window.clarity('consent'); }]); // advertisement _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.advertisement == true) { //console.log("advertisement cookies enabled"); //Google Tag Manager set ad_storage window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} // Update Tagmanager to grant consent for Ads trigger gtag('consent', 'update', { 'ad_user_data': 'granted', 'ad_personalization': 'granted', 'ad_storage': 'granted', 'analytics_storage': 'granted' }); //End Google Tag Manager } }]); // functionality _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.functionality == true) { //console.log("functionality cookies enabled"); } }]); </script> </body></html>

CINXE.COM

PostgreSQL Wire Protocol with CrateDB