dsn => $dsn,
user => $user,
password => $password,
+ loader_options => { preserve_case => 1 },
+ quote_char => '"',
data_types => {
# http://www.postgresql.org/docs/7.4/interactive/datatype.html
#
# Numeric Types
boolean => { data_type => 'boolean' },
bool => { data_type => 'boolean' },
+ 'bool default false'
+ => { data_type => 'boolean', default_value => \'false' },
bigint => { data_type => 'bigint' },
int8 => { data_type => 'bigint' },
'time with time zone' => { data_type => 'time with time zone' },
'time(2) with time zone' => { data_type => 'time with time zone', size => 2 },
timestamp => { data_type => 'timestamp' },
- 'timestamp default current_timestamp'
- => { data_type => 'timestamp', default_value => \'current_timestamp' },
+ 'timestamp default now()'
+ => { data_type => 'timestamp', default_value => \'current_timestamp',
+ original => { default_value => \'now()' } },
'timestamp(2)' => { data_type => 'timestamp', size => 2 },
'timestamp without time zone' => { data_type => 'timestamp' },
'timestamp(2) without time zone' => { data_type => 'timestamp', size => 2 },