Re: pgadmin string data output...

On Tue, 2011-09-20 at 07:24 -0400, boris wrote:
> On 09/20/2011 03:13 AM, Guillaume Lelarge wrote:
> > On Mon, 2011-09-19 at 21:27 -0400, boris wrote:
> >> hi all,
> >> I guess , this is very basic question, but I don't see any options to
> >> fix it.
> >> why when I do select , strings in "data output" are in quotes and
> >> parenthesis?
> >>
> >> How do I turn it off? I would like to see plain data...
> >>
> >
> > Do you mean when you copy and paste the result? in that case, each
> > columns' value could be between quotes. But the parenthesis, I have no
> > idea.
> >
> > So, is it when you copy and paste the results? or is it in the results
> > grid?
> >
> >
> it's in the results grid.
> data looks like:
>
> (aaaa)
> (bbb)
> ("aaa bbb")
> ("aaa ccc")
> ...
>
> In the morning I found the reason right away :-)
>
> CREATE TABLE "temp".test1
> (
> word character varying(255) NOT NULL,
> CONSTRAINT test1_pkey PRIMARY KEY (word)
> )
> WITH (
> OIDS=FALSE
> );
>
> I was making this select:
> select lower(w.name) from temp.test1 w
>
> w.name should be w.word, of course... Now it shows data without parenthesis.
>
> so, can anyone tell me what has been called in this case (w.name)?
>

I don't remember the exact explanation, but using "name" brings you the
whole row in a single column. For example, add a column and you'll get
this:

b1=# select * from temp.test1;
word | word2
------+-------
a | b
(1 row)

b1=# select lower(w.name) from temp.test1 w;
lower
-------
(a,b)
(1 row)

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com