Re: query to match '\N' - Mailing list pgsql-general

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