Re: stupid insert error

David Bear <David.Bear@asu.edu> writes:
> I guess I'm too stupid to see the error, but I don't understand why
> the following fails.

> insert into person3 (asuid, fname, lname, addedby, addedon,
> slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL);
> ERROR:  column "123455" does not exist

You want single quotes not double quotes.  Double quotes are for
identifiers, single quotes are for literals.  See
http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
and the following section.

            regards, tom lane