Skip to content

Instantly share code, notes, and snippets.

@ManishLSN

ManishLSN/basic pg table

Created February 23, 2018 13:20
Show Gist options
  • Save ManishLSN/c98099c34f27d8e22968f8e16e724ed3 to your computer and use it in GitHub Desktop.
Save ManishLSN/c98099c34f27d8e22968f8e16e724ed3 to your computer and use it in GitHub Desktop.
Download ZIP
basic users table
Raw
basic pg table
CREATE TABLE public.users
(
id serial NOT NULL,
email character varying(155),
pwd text NOT NULL,
u_name character varying(155),
f_name character varying(100),
l_name character varying(100),
dob timestamp without time zone NOT NULL,
platform smallint DEFAULT 0,
device_key text,
mobile text,
is_active smallint DEFAULT 1,
created_at timestamp without time zone,
PRIMARY KEY (id)
)
WITH (
OIDS = FALSE
)
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment