Re: query to match '\N'

From: Lew <lew(at)lewscanon(dot)nospam>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: query to match '\N'
Date: 2007-07-31 12:58:24
Message-ID: foOdnf6YQ-dsrDLbnZ2dnUVZ_oTinZ2d@comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-07-31 13:48:10 Re: Core reported from vaccum function.
Previous Message Dave Page 2007-07-31 12:32:46 Re: psql 8.2 client vs pg 8.1 server problem