ad 1) from http://docs.sqlalchemy.org/en/rel_0_7/core/schema.html#defining-sequences :
The Sequence object also has the ability to be executed standalone like a SQL expression, which has the effect of calling its “next value” function: seq = Sequence('some_sequence') nextid = connection.execute(seq) ad 2) i determine sequences from models by inspection: from sqlalchemy import Sequence ... if len(table.primary_key.columns) == 1: pk = list(table.primary_key.columns)[0] if isinstance(pk.default, Sequence): ... On Tue, May 29, 2012 at 8:58 AM, Chris Withers <ch...@simplistix.co.uk> wrote: > Hi All, > > How do I create a postgres sequence independent of a table using sqlalchemy? > > How do I select the next value from a sequence that forms part of a postgres > table, starting with the SQLAlchemy Table object? > > cheers, > > Chris > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > - http://www.simplistix.co.uk > > -- > 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. > -- 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.