1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| -- creation database --
CREATE DATABASE rapports
WITH OWNER = postgres
ENCODING = 'Latin1'
TABLESPACE = pg_default
TEMPLATE template0
LC_COLLATE = 'C'
LC_CTYPE = 'C'
CONNECTION LIMIT = -1;
creation table --
set client_encoding = 'latin1';
CREATE TABLE biblio
(
numero_source character varying,
codenat_source character varying,
code_source character varying,
collaborateurs character varying,
annee_edition character varying,
titre1 character varying,
titre2 character varying,
auteur character varying,
pages character varying,
lieu_edition character varying,
editeur character varying
)
WITH (OIDS=FALSE);
ALTER TABLE biblio
OWNER TO postgres;
alter table biblio owner to rapports; |
Partager