views:

385

answers:

2

What is the sqlalchemy equivalent column type for 'money' and 'OID' column types in Postgres?

A: 

This is all I could find: http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html

You can make your own type if you want as well.

Arthur Thomas
+2  A: 

we've never had an "OID" type specifically, though we've supported the concept of an implicit "OID" column on every table through the 0.4 series, primarily for the benefit of postgres. However since user-table defined OID columns are deprecated in Postgres, and we in fact never really used the OID feature that was present, we've removed this feature from the library.

If a particular type is not supplied in SQLA, as an alternative to specifying a custom type, you can always use the NullType which just means SQLA doesn't know anything in particular about that type. If psycopg2 sends/receives a useful Python type for the column already, there's not really any need for a SQLA type object, save for issuing CREATE TABLE statements.

zzzeek