Re: Problem with Select output

Hi all
Can anybody please help me in this?

Regards
Srini

--- srini vasan <srinibalaji_82(at)yahoo(dot)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(at)postgresql(dot)org)
>

__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com