Re: Bug with passwords that include apostrophes

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



-----Original Message-----
From: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Christopher
Kings-Lynne
Sent: Thursday, June 15, 2006 10:29 PM
To: pgadmin-support@postgresql.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@postgresql.orgso that your      message can get through to the mailing list cleanly