File: init_schema.sql

package info (click to toggle)
slony1-2 2.2.11-6
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 9,040 kB
  • sloc: ansic: 21,487; sh: 12,997; sql: 11,337; xml: 9,202; javascript: 6,409; perl: 2,829; yacc: 2,698; lex: 1,356; makefile: 738; awk: 24; lisp: 8
file content (13 lines) | stat: -rw-r--r-- 362 bytes parent folder | download | duplicates (10) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
create domain alt_timestamptz timestamptz;

CREATE TABLE table1(
  id            SERIAL PRIMARY KEY, 
  ts            TIMESTAMP,
  tsz           alt_timestamptz,
  ds            DATE,
  nowts         TIMESTAMP DEFAULT NOW(),
  nowtsz        TIMESTAMPTZ DEFAULT NOW(),
  nowds         DATE DEFAULT NOW(),
  tsz_array     TIMESTAMPTZ[] DEFAULT '{now(),now()}'
);