Thanks your suggestion first! And I got another question now. The Column name has space like below.
user = Table('tbl_user', metadata,\ Column('name', VARCHAR(20)),\ Column('phone number', VARCHAR(20))) 1. when select user.c.get('phone number') =='12345678')) 2. when insert {user.c.get('phone number):''7890'} I should get phone number object in the ugly way. any function in sqlalcemy could alias column name as below? 1. when select user.c.name =='nick' 2. when insert name = 'lisa' On Jan 23, 12:22 am, Alex K <klizhen...@gmail.com> wrote: > You can definitely access this table, using SQL engine only > > my_table = Table('my_table', metadata, > Column('my_field', String) > ) > > #now we can perform the query > session.connection().execute(my_table.select()) > #more info here:http://www.sqlalchemy.org/docs/05/sqlexpression.html > > On Jan 22, 11:56 am, Ikuta <keng...@gmail.com> wrote: > > > Hi > > > I have a question here, is it possible to access a read-only table > > (without primary_key) in ORM method? > > > Thanks! > > > Ikuta --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---