omni_datasets
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
omni_datasets | 0.1.0 | FEAT | Apache-2.0 | C |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 2947 | omni_datasets | No | No | No | Yes | No | No | omni_datasets |
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PIGSTY | 0.1.0 | 1817161514 | omni_datasets | - |
| RPM | PIGSTY | 0.1.0 | 1817161514 | omnigres_$v | - |
| DEB | PIGSTY | 0.1.0 | 1817161514 | postgresql-$v-omnigres | - |
Build
You can build the RPM / DEB packages for omni_datasets using pig build:
pig build pkg omni_datasets # build RPM / DEB packages
Install
You can install omni_datasets directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
pig repo add pgsql -u # Add repo and update cache
Install the extension using pig or apt/yum/dnf:
pig install omni_datasets; # Install for current active PG version
pig ext install -y omni_datasets -v 18 # PG 18
pig ext install -y omni_datasets -v 17 # PG 17
pig ext install -y omni_datasets -v 16 # PG 16
pig ext install -y omni_datasets -v 15 # PG 15
pig ext install -y omni_datasets -v 14 # PG 14
dnf install -y omnigres_18 # PG 18
dnf install -y omnigres_17 # PG 17
dnf install -y omnigres_16 # PG 16
dnf install -y omnigres_15 # PG 15
dnf install -y omnigres_14 # PG 14
apt install -y postgresql-18-omnigres # PG 18
apt install -y postgresql-17-omnigres # PG 17
apt install -y postgresql-16-omnigres # PG 16
apt install -y postgresql-15-omnigres # PG 15
apt install -y postgresql-14-omnigres # PG 14
Create Extension:
CREATE EXTENSION omni_datasets;
Usage
The omni_datasets extension provides access to sample datasets, currently including the Northwind database.
Northwind Dataset
CREATE EXTENSION omni_datasets;
CREATE SCHEMA northwind;
SELECT omni_datasets.instantiate_northwind(schema => 'northwind');
The Northwind dataset is a classic sample database originally from Microsoft Access/SQL Server, using a PostgreSQL-compatible version maintained by Yugabyte. It provides a small but realistic business dataset with tables for customers, orders, products, employees, and more.
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.