Re: Bug with passwords that include apostrophes - Mailing list pgadmin-support

From Richard Cook
Subject Re: Bug with passwords that include apostrophes
Date
Msg-id 007001c69134$2463e050$a400000a@sivana.net
Whole thread Raw
In response to Bug with passwords that include apostrophes  (Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>)
List pgadmin-support

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
 




pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: init script for redhat
Next
From: "Dave Page"
Date:
Subject: Re: Postgis Manual