pc wrote:
oh yes! You all are exactly right.I exported a table and all nulls became \N and when i imported it \n remained \N and did not convert to NULL.So I updates all \N s with '' now. Thank you all for your input.I got to learn a lot from you.
Since the empty string is different from NULL, doesn't that mean that the imported data still differ from the exported?
-- Lew ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster