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.