File: init_schema.sql

package info (click to toggle)
slony1-2 2.0.4-1
  • links: PTS
  • area: main
  • in suites: squeeze
  • size: 6,716 kB
  • ctags: 4,089
  • sloc: ansic: 17,784; sh: 12,592; xml: 8,185; sql: 7,314; yacc: 2,468; perl: 2,376; lex: 1,321; makefile: 909; awk: 24
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()}'
);