Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Table: datawork.ron
- -- DROP TABLE IF EXISTS datawork.ron;
- CREATE TABLE IF NOT EXISTS datawork.ron
- (
- id BIGSERIAL NOT NULL,
- col1 smallint NOT NULL DEFAULT (((random() * (8)::double precision) + (1)::double precision))::smallint,
- col2 smallint NOT NULL DEFAULT (((random() * (8)::double precision) + (1)::double precision))::smallint,
- col3 smallint NOT NULL DEFAULT (((random() * (8)::double precision) + (1)::double precision))::smallint,
- col4 smallint NOT NULL DEFAULT (((random() * (8)::double precision) + (1)::double precision))::smallint,
- col5 smallint NOT NULL DEFAULT (((random() * (8)::double precision) + (1)::double precision))::smallint,
- CONSTRAINT ron_pkey PRIMARY KEY (id)
- )
- TABLESPACE pg_default;
- ALTER TABLE IF EXISTS datawork.ron
- OWNER to postgres;
- INSERT INTO datawork.ron DEFAULT VALUES;
- SELECT * FROM datawork.ron;
Add Comment
Please, Sign In to add comment