Preserving Timestamp Information - Mailing list pgsql-novice

From Lola Lee
Subject Preserving Timestamp Information
Date
Msg-id 42D8F509.1020208@his.com
Whole thread Raw
Responses Re: Preserving Timestamp Information  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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.

I can create insert queries for all of these if I have to but I need to
know how to force preservation of the time stamp.

--
Lola - mailto:lola@his.com
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
Terrorismus delendus est! (Terrorism must be destroyed utterly!)
I'm in Bowie, MD, USA, halfway between DC and Annapolis.

pgsql-novice by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: plpgsql trigger problem
Next
From: Keith Worthington
Date:
Subject: Re: User Context Variables