Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group