Ticket #1212: ts_test.sql

File ts_test.sql, 0.6 kB (added by aklaver, 3 years ago)

Postgres CREATE TABLE code

Line 
1 CREATE TABLE timestamp_test (
2     id integer NOT NULL,
3     txt_fld text,
4     ts_fld timestamp with time zone
5 );
6
7 ALTER TABLE ONLY timestamp_test
8     ADD CONSTRAINT timestamp_test_pkey PRIMARY KEY (id);
9
10
11 INSERT INTO timestamp_test VALUES (1, 'test1', '2009-03-11 12:35:43.065678-07');
12 INSERT INTO timestamp_test VALUES (3, 'test3', '2009-03-11 13:37:01.166354-07');
13 INSERT INTO timestamp_test VALUES (2, 'test2', '2009-03-11 12:42:15.276405-07');
14 INSERT INTO timestamp_test VALUES (4, 'test3', '2009-03-11 14:37:48.993075-07');
15 INSERT INTO timestamp_test VALUES (5, 'test3', '2009-03-12 12:38:07.722856-07');