--
--





--
-- Name: personne; Type: TABLE; Schema: public; Owner: test_pga
--

CREATE TABLE public.personne (
    id bigint NOT NULL,
    nom character varying(255),
    prenom character varying(255),
    date_naissance timestamp without time zone,
    ville_naissance character varying(255),
    telephone character varying(255),
    mail character varying(255),
    commentaire character varying(255),
    nom_formate character varying(255),
    prenom_formate character varying(255)
);


ALTER TABLE public.personne OWNER TO test_pga;

--
-- Data for Name: personne; Type: TABLE DATA; Schema: public; Owner: test_pga
--

COPY public.personne (id, nom, prenom, date_naissance, ville_naissance, telephone, mail, commentaire, nom_formate, prenom_formate) FROM stdin;
3	GATES	Bill	1955-10-28 00:00:00	SEATTLE	0707070707	bill@test.net	Commentaire confidentiel	gates	bill
1	PELTIER	Nicolas	1981-10-01 00:00:00	ANGOULEME	0505050505	nicolas@scub.net	Commentaire personnel	peltier	nicolas
4	MUSK	Elon	1971-06-28 00:00:00	PRETORIA	0808080808	elon@test.net	Donnée personnelle	musk	elon
2	TRAUMAT	Stéphane	1978-08-01 00:00:00	BORDEAUX	0606060606	stephane@scub.net	Donnée confidentielle	traumat	stephane
\.



--
-- Name: personne personne_pk; Type: CONSTRAINT; Schema: public; Owner: test_pga
--

ALTER TABLE ONLY public.personne
    ADD CONSTRAINT personne_pk PRIMARY KEY (id);


--
--

