[GENERAL] query to match '\N'

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 que

Re: [GENERAL] query to match '\N'

wow! works for me! Thank you !! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] query to match '\N'

> // Integrate Your World // > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org/ oh yes! You all are exactly right.I exported a table and all nulls became \N and

[GENERAL] how to redirect output to a file

Hi, How to redirect the output of an sql command to a file? Thanks in advance ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] How to view temp tables

My php code is creating temporary table named mytemp,but when I run a selec * from mytemp I cannot see the table.How can I see the table from postgresql command prompt? ---(end of broadcast)--- TIP 6: explain analyze is your friend