Skip to content

Instantly share code, notes, and snippets.

@an01f01
Last active July 8, 2022 11:54
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 an01f01/f53b4479ecfad03211fe9de552e056d4 to your computer and use it in GitHub Desktop.
Save an01f01/f53b4479ecfad03211fe9de552e056d4 to your computer and use it in GitHub Desktop.
CREATE extension IF NOT EXISTS "uuid-ossp";
-- Table: public.books
CREATE TABLE IF NOT EXISTS public.books
(
bookid uuid NOT NULL DEFAULT uuid_generate_v4(),
title character varying COLLATE pg_catalog."default",
book_info jsonb,
CONSTRAINT books_pkey PRIMARY KEY (bookid)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment