Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
labs:postgresql [2016/06/27 16:06] – [Viewing Table Information] admin | labs:postgresql [2016/06/27 16:09] – [Creating Tables] admin | ||
---|---|---|---|
Line 60: | Line 60: | ||
===== Creating Tables ===== | ===== Creating Tables ===== | ||
- | ==== Creating Sequences ==== | + | |
+ | Example: | ||
+ | |||
+ | CREATE TABLE table_name ( | ||
+ | id integer NOT NULL default nextval(' | ||
+ | eagle_id char(9), | ||
+ | floor_to_graffito_height varchar(30), | ||
+ | description text, | ||
+ | comment text, | ||
+ | translation text, | ||
+ | FOREIGN KEY ( eagle_id ) REFERENCES EAGLE_inscriptions(id), | ||
+ | PRIMARY KEY (id) | ||
+ | ); | ||
+ | ===== Creating Sequences | ||
| | ||