List, Sorry for the blank email previous to this one.
I'm working on a project to move student data from one database to another for some schools. I'm wondering if there is a quick way to do accomplish the following: 1) I'm moving data into postgres from a dbf, and no primary key for the new table has been defined. Do I have to use "raw" SQL or go into the database manager to define a primary key, or is there a built-in way? When I'm initially creating the table, I'm simply taking each column name and type from the dbf file and making a column object. Until I see the data in postgres, I have no idea what the primary key should be, so I'd have to do it after initial table creation. Or if I could define a temporary PK so that I can perform operations on the created table and data, that would work too. 2) Once I have the tables and data in postgres, I'm writing functions to move the data to a new database. The database is already defined, and they only thing I can do to it is add extra columns in a few tables. The designers have created no foreign keys on any tables, so I'm wondering if there's a way I can autoload the tables and still define foreign keys (maybe on a temporary basis?) so I can load mappers that will allow me to "plug in" the data from the tables created to hold the dbf data. 3) A few tables (like the "students" table) allow the addition of "custom_xxxxxx" columns to hold information not planned for in the original database design. Is there any way to add another column object to the table and have it perform an "ALTER TABLE ADD COLUMN"? Thanks for any hints or tips, Brian ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
