Installing and Using the dblink Extension in PostgreSQL and Greenplum
The dblink extension allows a PostgreSQL database to interact with a remote PostgreSQL database.
Prerequisites and Installation
To use dblink, you must compile and install it from the PostgreSQL source code. 1. Navigate to the contrib/dblink directory within your PostgreSQL source code.
2. Compile the extension using make.
3. Install it with ma ...
Posted on Fri, 28 Aug 2026 16:42:23 +0000 by nowaydown1
Implementing a Custom Vector Type for PostgreSQL with pgrx
Defining the Vector Structure
Our goal is to enable SQL statements like:
CREATE TABLE embeddings (embedding vector(3));
We start by defining a Rust struct that wraps a vector of floating-point numbers:
#[derive(Debug, serde::Deserialize, serde::Serialize)]
#[serde(transparent)]
pub struct VectorData {
components: Vec<f64>,
}
</f6 ...
Posted on Tue, 25 Aug 2026 16:51:34 +0000 by mjohnson025