sleect function(ssd_a) from ... where function is one of the built-in text function or one of your own written in some of the supported (by your version) procedure languages.
Regards. En un mensaje anterior, srini vasan escribió: > --- srini vasan <[EMAIL PROTECTED]> wrote: > > > Hi > > I am facing some issues with select query. The > > values of the columns in one table contains "\n" as > > a > > part of the value. So when I execute the select > > query > > on this table, I am getting the following output. > > > > # select * from stdhlr_subscriber_profile ; > > subscriber_id | ssd_a > > ---------------+---------- > > 470320000 | test > > value > > (1 row) > > > > But the value of ssd_a is "test\nvalue". I want the > > select output to print the value of ssd_a as > > "test\nvalue". ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend