Skip to content

Instantly share code, notes, and snippets.

@MattMS

MattMS/jsonb+uuid.sql

Created July 18, 2023 12:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MattMS/3a707d5b1a0f7f7d4bd7ebd7ad707000 to your computer and use it in GitHub Desktop.
Save MattMS/3a707d5b1a0f7f7d4bd7ebd7ad707000 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL table with JSONB referenced by UUID
Raw
jsonb+uuid.sql
CREATE TABLE doc (k UUID PRIMARY KEY DEFAULT gen_random_uuid(), v JSONB NOT NULL);
INSERT INTO doc (v) VALUES ('{"ok": true}');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment