Hello ANSI SQL uses double quotes only for SQL identifiers. For literals are used single quotes.
like SELECT col AS "some strange sql column identifier", 'some string value' FROM "some strange sql table identifier" so for case sensitive or strange (is keyword, contains space) sql identifiers use double quotes, for string constants use single quotes. some other database uses [] or ` . Regards Pavel 2010/6/23 Alexander Farber <alexander.far...@gmail.com>: > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
