Re: Preserving Timestamp Information

Lola Lee <lola@his.com> writes:
> How can I preserve timestamp for a set of data?  I'm using PostgreSQL
> 8.02.  I had to do a dump of my database and then at a later date I
> imported the data I had in several tables.  Here's an example:

> yw_id      weight  yarnweight_lud
> --
> 1    Cobweb    2005-01-13 15:21:50.654149
> 2    Lace Weight    2005-01-13 15:21:50.654149
> 3    Sock    2005-01-13 15:21:50.654149

> When I use the import wizard for Aqua Data Studio, it sets all values
> for yarnweight_lud to NULL.

That sounds like a pretty brain-dead "wizard".

Why don't you just use the dump file as it was designed to be used,
ie, feed it to pg_dump (or pg_restore, depending on format).

            regards, tom lane