--- title: Unleashing the power of vector embeddings with PostgreSQL description: This post explores the concept of word and sentence vector embeddings and how they can be used with Postgres. It introduces the pgvector Postgres extension and... canonical: https://daily.dev/posts/unleashing-the-power-of-vector-embeddings-with-postgresql-u4zzgz8db twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Unleashing the power of vector embeddings with PostgreSQL | daily.dev og:description: This post explores the concept of word and sentence vector embeddings and how they can be used with Postgres. It introduces the pgvector Postgres extension and... og:url: https://daily.dev/posts/unleashing-the-power-of-vector-embeddings-with-postgresql-u4zzgz8db og:image: https://api.daily.dev/og/posts/U4ZzGZ8db.png og:image:alt: Unleashing the power of vector embeddings with PostgreSQL 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. # Unleashing the power of vector embeddings with PostgreSQL **[Community Picks](https://daily.dev/sources/community)** · 7 min read · 7 upvotes · 0 comments ## Summary This post explores the concept of word and sentence vector embeddings and how they can be used with Postgres. It introduces the pgvector Postgres extension and demonstrates how to store and query vectors in a Postgres database. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#bots](https://daily.dev/tags/bots), [#pgvector](https://daily.dev/tags/pgvector), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/unleashing-the-power-of-vector-embeddings-with-postgresql-u4zzgz8db) ```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":"Unleashing the power of vector embeddings with PostgreSQL","url":"https://daily.dev/posts/unleashing-the-power-of-vector-embeddings-with-postgresql-u4zzgz8db","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/unleashing-the-power-of-vector-embeddings-with-postgresql-u4zzgz8db"},"datePublished":"2024-02-29T05:18:38.459Z","dateModified":"2024-05-24T02:14:46.263Z","description":"This post explores the concept of word and sentence vector embeddings and how they can be used with Postgres. It introduces the pgvector Postgres extension and...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/173fb51812696034f85246598954711a?_a=AQAEufR","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/173fb51812696034f85246598954711a?_a=AQAEufR","isAccessibleForFree":true,"articleSection":"Community Picks","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":"Community Picks","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community","url":"https://daily.dev/sources/community"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/unleashing-the-power-of-vector-embeddings-with-postgresql-u4zzgz8db","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":7},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"bots,pgvector,postgresql","timeRequired":"PT7M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Community Picks","item":"https://daily.dev/sources/community"},{"@type":"ListItem","position":3,"name":"Unleashing the power of vector embeddings with PostgreSQL"}]} ```