lun. 05 août 2013, 17h14
Jean à Grenoble
atoutfox.public.association
Re: [postgres] unicode
et mon pdf mais version 9.0.4 (je vais tenter de mettre la clause dans pgadmin3,
je vais bien voir s'il accepte) :
Nom
CREATE TABLE — Définir une nouvelle table
Synopsis
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE nom_table ( [
{ nom_colonne type_donnees [ DEFAULT default_expr ] [ contrainte_colonne [ ... ] ]
| contrainte_table
| LIKE table_parent [ option_like ... ] }
[, ... ]
] )
[ INHERITS ( table_parent [, ... ] ) ]
[ WITH ( parametre_stockage [= valeur] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE tablespace ]
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE nom_table
OF nom_type [ (
{ nom_colonne WITH OPTIONS [ DEFAULT default_expr ] [ contrainte_colonne [ ... ] ]
| contrainte_table }
[, ... ]
) ]
[ WITH ( parametre_stockage [= valeur] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE tablespace ]
où contrainte_colonne
peut être :
[ CONSTRAINT nom_contrainte ]
{ NOT NULL | NULL |
CHECK ( expression ) |
UNIQUE parametres_index |
PRIMARY KEY parametres_index |
EXCLUDE [ USING methode_index ] ( élément_exclude WITH opérateur [, ... ] )
paramètres_index [ WHERE ( prédicat ) ] |
REFERENCES table_reference [ ( colonne_reference ) ] [ MATCH FULL
| MATCH PARTIAL | MATCH SIMPLE ]
[ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
A+
Jean à Grenoble
Permalink : http://www.atoutfox.org/nntp.asp?ID=0000012732