Re: Single quotes vs. double quotes when setting a pwd and other cmds - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Single quotes vs. double quotes when setting a pwd and other cmds
Date
Msg-id 4C21CF80.7000501@lelarge.info
Whole thread Raw
In response to Single quotes vs. double quotes when setting a pwd and other cmds  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Le 23/06/2010 11:03, Alexander Farber a écrit :
> 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.
>

Use double quotes for identifiers, and single quotes for string values.

The password is a string, so you use single quotes with it. The username
is an identifier, so you (can) use double quotes with it.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Single quotes vs. double quotes when setting a pwd and other cmds
Next
From: Pavel Stehule
Date:
Subject: Re: Single quotes vs. double quotes when setting a pwd and other cmds