Re: Quoting table names with SQLObject+PostgreSQL - Max Ischenko - com.googlegroups.pylons-discuss

2 messages in com.googlegroups.pylons-discussRe: Quoting table names with SQLObjec...

From	Sent On	Attachments
Konstantin Alexandrov	25 Jun 2007 19:41
Max Ischenko	26 Jun 2007 00:16

Subject:	Re: Quoting table names with SQLObject+PostgreSQL
From:	Max Ischenko (isch...@public.gmane.org)
Date:	06/26/2007 12:16:07 AM
List:	com.googlegroups.pylons-discuss

On 6/26/07, Konstantin Alexandrov
<iwuv...@public.gmane.org> wrote:

Hello.

I have problem with the table named 'user': * psycopg.ProgrammingError: ERROR: syntax error at or near "user" LINE 1: INSERT INTO user (id, last_name, country_id, city, registrat... ^ INSERT INTO user (id, last_name, country_id, city, registration_date, first_name, phone, personal_info, profile_title, skype, birth_day, is_blocked, nickname, login, yid, jid, password, middle_name, gender, region, msn, avatar, icq, email) VALUES (1, '', NULL, '', '2007-06-26 06:34:47', '', '', '', '', '', NULL, 'f', '', 'negus', '', '', 'swordfish', '', '', '', '', '', '', ' iwuv...@public.gmane.org')*

It's because this table name 'user' have to be quoted in the SQL query to avoid conflicts. How to do that with SQLObject?

Check SQLObject docs or google for it. There is a way, althought I don't remember off the top of my head. But why using SQLObject when there is SQLAlchemy? ;)

Max.