Re: Problem with Select output - Mailing list pgsql-general

From Fernando Schapachnik
Subject Re: Problem with Select output
Date
Msg-id 20041222161232.GI328@bal740r0.mecon.gov.ar
Whole thread Raw
In response to Re: Problem with Select output  (srini vasan <srinibalaji_82@yahoo.com>)
List pgsql-general
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".

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Problem with Select output
Next
From: Martijn van Oosterhout
Date:
Subject: Re: DELETE versus TRUNCATE during pg_dump....