File: init_schema.sql

package info (click to toggle)
slony1-2 2.2.3-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 8,836 kB
  • ctags: 5,283
  • sloc: ansic: 21,239; sh: 13,008; sql: 11,299; xml: 9,172; perl: 2,803; yacc: 2,698; lex: 1,356; makefile: 747; 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()}'
);