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

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