Skip site navigation (1) Skip section navigation (2)

stupid insert error

From: David Bear <David(dot)Bear(at)asu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: stupid insert error
Date: 2005-06-24 00:12:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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

is the double quote byting me?
David Bear
phone: 	480-965-8257
fax: 	480-965-9189
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
 "Beware the IP portfolio, everyone will be suspect of trespassing"


pgsql-admin by date

Next:From: Michael FuhrDate: 2005-06-24 00:41:33
Subject: Re: stupid insert error
Previous:From: Jeff FrostDate: 2005-06-23 23:01:44
Subject: Re: restoring wal archive and pg_xlog dir

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group