On Wed, 25 Apr 2001, Joel Burton wrote:
> Is there anything that datetime did that timestamp doesn't?
datetime is provided to ensure compatibility with older releases, although
they are not guranteed to exist in future releases (chapter 3.4 users
guide)
> Could you
>
> pg_dump | sed | psql
>
> to change the datetimes to timestamp?
No. pg_dump will read from the database while psql will modify it and
there can be conflicts. It is safe to
pg_dumpall -c | sed > tmpfile
psql -d template1 -f tmpfile
Anuradha