> If I use pg_dump to backup a database table (or just its schema) and the
> table contains a date field defaulted to the current date then the
resulting
> table create statement is invalid.
>
> These shell commands demonstarte the problem:
> createdb db1
> createdb db2
> psql -c'create table t (d date default current_date)' db1
> pg_dump -s db1 | psql db2
>
> psql reports ERROR: parser: parse error at or near "'"
>
> This is using Postgres 6.5.0
I also should have listed the create statement produced by pg_dump
CREATE TABLE "t" (
"d" date DEFAULT date( 'current'::datetime + '0 sec'));