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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
