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' },
'char' => { data_type => 'char', size => 1 },
text => { data_type => 'text' },
# varchar with no size has unlimited size, we rewrite to 'text'
- varchar => { data_type => 'text' },
+ varchar => { data_type => 'text',
+ original => { data_type => 'varchar' } },
# Datetime Types
date => { data_type => 'date' },
interval => { data_type => 'interval' },
'interval(2)' => { data_type => 'interval', size => 2 },
- time => { data_type => 'time without time zone' },
- 'time(2)' => { data_type => 'time without time zone', size => 2 },
- 'time without time zone' => { data_type => 'time without time zone' },
- 'time(2) without time zone' => { data_type => 'time without time zone', size => 2 },
+ time => { data_type => 'time' },
+ 'time(2)' => { data_type => 'time', size => 2 },
+ 'time without time zone' => { data_type => 'time' },
+ 'time(2) without time zone' => { data_type => 'time', size => 2 },
'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 },