postgresql_devdb_users_2025-08-24.sql•1.72 kB
--
-- PostgreSQL database dump
--
--
-- Name: users; Type: TABLE; Schema: public; Owner: devuser
--
DROP TABLE IF EXISTS "users";
CREATE TABLE "users" (
id integer NOT NULL,
user_name character varying(50) NOT NULL,
email character varying(100) NOT NULL,
signup_date date
);
ALTER TABLE "users" OWNER TO devuser;
--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: devuser
--
CREATE SEQUENCE users_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE "users_id_seq" OWNER TO devuser;
--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: devuser
--
ALTER SEQUENCE users_id_seq OWNED BY "users".id;
--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: devuser
--
ALTER TABLE ONLY "users" ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: devuser
--
INSERT INTO "users" VALUES (1, '홍길동', 'gildong@example.com', '2024-01-15');
INSERT INTO "users" VALUES (2, '이순신', 'sunsin@example.com', '2024-02-20');
INSERT INTO "users" VALUES (3, '세종대왕', 'sejong@example.com', '2024-03-10');
--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: devuser
--
SELECT pg_catalog.setval('users_id_seq', 3, true);
--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: devuser
--
ALTER TABLE ONLY "users"
ADD CONSTRAINT users_email_key UNIQUE (email);
--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: devuser
--
ALTER TABLE ONLY "users"
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
-- PostgreSQL database dump complete
--