Single quotes vs. double quotes when setting a pwd and other cmds

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Single quotes vs. double quotes when setting a pwd and other cmds
Date: 2010-06-23 09:03:04
Message-ID: AANLkTinJHM9kxuHeHMyHSY6Rekyx17dVlAsuiDXhz-p1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

why aren't double quotes accepted below?

db1=# alter user user1 password "pass1";
ERROR: syntax error at or near ""pass1""
LINE 1: alter user user1 password "pass1";
^
db1=# alter user user1 password 'pass1';
ALTER ROLE

Is there a thumb rule to know when to use which quotes?
I'm often confused by them when using psql.

Thank you
Alex

PS: Using postgresql-server-8.3.6 @ OpenBSD 4.5

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2010-06-23 09:10:24 Re: Single quotes vs. double quotes when setting a pwd and other cmds
Previous Message Dave Page 2010-06-23 09:01:31 Re: libpython - cannot open shared object file