Skip to content

Instantly share code, notes, and snippets.

@achampav

achampav/cre_tbl_villes.sql

Created July 15, 2019 16:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save achampav/d57e89d5e1d103db35f62cb07bec163e to your computer and use it in GitHub Desktop.
Save achampav/d57e89d5e1d103db35f62cb07bec163e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cre_tbl_villes.sql
-- Connexion à l'utilisateur cadastre sur la base de données cadastredb du serveur postgresql1101
create table villes(id serial,ville character varying(400) not null,constraint pk_villes primary key(id));
insert into villes(ville) values ('Valbonne'),('Antibes'),('Seillans'),('La Gaude'),
('Biot'),('Vallauris'),('Golfe-Juan'),('Juan-Les-Pins'),('Villeneuve-Loubet');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment