Обсуждение: Problem with Select output
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". Note: I have used COPY command to copy the value to a file. In that file ssd_a is saved as "test\nvalue". There is no newline substitution. I want to achieve the same with select query. I am using PSQl verison 7.2.2 Can you please suggest me how to do this? Regards Srini. __________________________________ Do you Yahoo!? All your favorites on one personal page � Try My Yahoo! http://my.yahoo.com
Hi all Can anybody please help me in this? Regards Srini --- srini vasan <srinibalaji_82@yahoo.com> 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". > > Note: > I have used COPY command to copy the value to a > file. In that file ssd_a is saved as "test\nvalue". > There is no newline substitution. I want to achieve > the same with select query. > > I am using PSQl verison 7.2.2 > > Can you please suggest me how to do this? > > Regards > Srini. > > > > __________________________________ > Do you Yahoo!? > All your favorites on one personal page � Try My > Yahoo! > http://my.yahoo.com > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) > __________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com
On Wed, Dec 22, 2004 at 07:50:56AM -0800, srini vasan wrote: Hi, > Can anybody please help me in this? You could use the replace(text,text,text) function: alvherre=# create table foo (a text); CREATE TABLE alvherre=# insert into foo values ('hola alvherre'# '); INSERT 155224 1 alvherre=# select * from foo; a ------- hola (1 fila) alvherre=# select replace(a, '\n', '\\n') from foo; replace --------- hola\n (1 fila) -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "Para tener más hay que desear menos"
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 <srinibalaji_82@yahoo.com> 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".