Skip site navigation (1) Skip section navigation (2)

Preserving Timestamp Information

From: Lola Lee <lola(at)his(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Preserving Timestamp Information
Date: 2005-07-16 11:52:41
Message-ID: 42D8F509.1020208@his.com (view raw or flat)
Thread:
Lists: 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(at)his(dot)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.

Responses

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2005-07-16 12:40:34
Subject: Re: User Context Variables
Previous:From: Jaime CasanovaDate: 2005-07-15 22:19:01
Subject: Re: plpgsql trigger problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group