Re: Problem with Select output

From: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
To: srini vasan <srinibalaji_82(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with Select output
Date: 2004-12-22 16:12:32
Message-ID: 20041222161232.GI328@bal740r0.mecon.gov.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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".

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-12-22 16:20:11 Re: DELETE versus TRUNCATE during pg_dump....
Previous Message Alvaro Herrera 2004-12-22 16:06:47 Re: Problem with Select output