I am developing a system to take a generic data structure and store it in a PostgreSQL database. The data structure contains several entries of the following:
insert a record into table1 field1 value1 field2 value2 insert a record into table2 field1 value1 field2 value2 Data for different tables is stored in each 'data set'. When I get this to the database I want to: insert a blank record into tablex populate fieldx of new record with valuex I could implement this with some if statements based on the table name, then INSERT INTO x (...) VALUES (...), but I would prefer to kept the structure as generic as possible. Is it possible in PostgreSQL to construct a blank record without specifying a list of fields and values in an INSERT statement (so I can perform a collection for UPDATEs to populate the blank record)? Ashley ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])