Re: Bug with passwords that include apostrophes

["Richard Cook" <richard(at)aspworld(dot)com>]

How do I get an email address removed from this list?



-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Christopher
Kings-Lynne
Sent: Thursday, June 15, 2006 10:29 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Bug with passwords that include apostrophes

pgAdmin version: latest bundled
OS: Windows XP

Description
-----------

Attempting to log into a database with pgAdmin using a password that
contains the apostrophe (') character causes this error:

"An error has occurred.

Error connecting to the server: missing "=" after "asdf" in connection info
string."

It's almost certain you have the same problem connecting with a username
with an apostrophe, or to a db name with one.

In the connection string you need to go:

password='asdf\'fdsa' dbname='dbname'

To properly escape it.

Chris




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
       message can get through to the mailing list cleanly