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
Bryan White