query to match '\N'

[pc <chavanpriya@xxxxxxxxx>]

Hi,

I have a table test with columns  col1 col2.col2 contains an entry
'\N' .I want to select all entries which have '\N'  in col2.How do i
do that?

select * from test where col2 like '\N' ;
select * from test where col2 like '\\N' ;

both return 0 rows.Could some one please tell me the right query?


Thanks
Priya


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match