How to UPDATE record ?

[JackTheRussel]

Hi.

I have table called users:

name  | password | project | pr
aaron   passwd     default    wysiwyg
john    passwd2    proj2    sams

Now I ty to update my table:

UPDATE users set project ="default2" WHERE name = aaron;

OR

UPDATE users set project ="default2" WHERE name = "aaron";

But I always get error:

ERROR: Attribute 'default2' not found

What should I do ?

 

[feherke]

Hi

Use single quotes ( ' ) to delimit strings. Double quotes ( " ) are for identifiers with special characters.

[b]update[/b] users [b]set[/b] project=[i][red]'[/red]default2[red]'[/red][/i] [b]where[/b] name=[i][red]'[/red]aaron[red]'[/red][/i];

http://postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS

Feherke.

http://rootshell.be/~feherke/

 

[JackTheRussel]

Thanks feherke.

I'm totally newbie in PostgreSQL.

I have used to use MySQL database.