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

From Christopher Kings-Lynne
Subject Bug with passwords that include apostrophes
Date
Msg-id 4492175A.2030607@calorieking.com
Whole thread Raw
Responses Re: Bug with passwords that include apostrophes  ("Dave Page" <dpage@vale-housing.co.uk>)
Re: Bug with passwords that include apostrophes  ("Richard Cook" <richard@aspworld.com>)
List pgadmin-support
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





pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: init script for redhat
Next
From: "Dave Page"
Date:
Subject: Re: Bug with passwords that include apostrophes