Bug with passwords that include apostrophes

From: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug with passwords that include apostrophes
Date: 2006-06-16 02:28:42
Message-ID: 4492175A.2030607@calorieking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-06-16 07:22:12 Re: Bug with passwords that include apostrophes
Previous Message Dave Page 2006-06-15 12:54:00 Re: init script for redhat