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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
