Harald Armin Massa wrote:
I am using fields of type "inet" to store guids in PostgreSQL.
I can view them quite nice within pgAdmin grids.
when I select a cell, copy its content and paste it into notepad or
sqlsheet ..., the result is:
"1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9"
with double-quotes. PostgreSQL uses doublequotes only for mixed case
identifiers, not for data.
So to use that paste in a query like
select foo from bar where barid='1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9'
I have to manually change the quotemarks.
It's nice of pgAdmin to ADD quotes, please, also add the right quotes.
See the result copy quoting options:
http://www.pgadmin.org/docs/1.6/options-tab3.html
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
