Re: Problem with Select output

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