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. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.