跳转到主要内容

omni_datasets

Dataset provisioning

omni_datasets : Dataset provisioning

Overview

ID Extension Package Version Category License Language
2947 omni_datasets omni_datasets 0.1.0 FEAT Apache-2.0 C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
----d-- No No No Yes no no
Relationships
Schemas omni_datasets
See Also faker pg_fact_loader db_migrator postgres_fdw dbt2

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT PIGSTY 0.1.0 18 17 16 15 14 omni_datasets -
RPM PIGSTY 0.1.0 18 17 16 15 14 omnigres_$v -
DEB PIGSTY 0.1.0 18 17 16 15 14 postgresql-$v-omnigres -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64 N/A N/A N/A N/A N/A
el8.aarch64 N/A N/A N/A N/A N/A
el9.x86_64 N/A N/A N/A N/A N/A
el9.aarch64 N/A N/A N/A N/A N/A
el10.x86_64 N/A N/A N/A N/A N/A
el10.aarch64 N/A N/A N/A N/A N/A
d12.x86_64 N/A N/A N/A N/A N/A
d12.aarch64 N/A N/A N/A N/A N/A
d13.x86_64 N/A N/A N/A N/A N/A
d13.aarch64 N/A N/A N/A N/A N/A
u22.x86_64 N/A N/A N/A N/A N/A
u22.aarch64 N/A N/A N/A N/A N/A
u24.x86_64 N/A N/A N/A N/A N/A
u24.aarch64 N/A N/A N/A N/A N/A
u26.x86_64 N/A N/A N/A N/A N/A
u26.aarch64 N/A N/A N/A N/A N/A

Source

Repository

docs.omnigres.org/omni_datasets/northwind/

pig build pkg omni_datasets;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install omni_datasets;		# install via package name, for the active PG version

pig install omni_datasets -v 18;   # install for PG 18
pig install omni_datasets -v 17;   # install for PG 17
pig install omni_datasets -v 16;   # install for PG 16
pig install omni_datasets -v 15;   # install for PG 15
pig install omni_datasets -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION omni_datasets;

Usage

omni_datasets: Dataset provisioning

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.