Thread: pgadmin string data output...

pgadmin string data output...

From
boris
Date:
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...

thanks.


Re: pgadmin string data output...

From
Guillaume Lelarge
Date:
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?


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



Re: pgadmin string data output...

From
Dave Page
Date:
On Tue, Sep 20, 2011 at 2:13 AM, Guillaume Lelarge
<guillaume@lelarge.info> 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?

Parentheses makes me think the OP has defined his tables with text[]
or varchar[] columns instead of plain text or varchar. In that case,
he would always see both parentheses and quotes.



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: pgadmin string data output...

From
boris
Date:
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)?

thanks.







Re: pgadmin string data output...

From
Guillaume Lelarge
Date:
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