I am attempting to write a simple routine which acts on a predefined list of tables. These tables appear in the Postgres back-end as well as in mdb files distributed by another system. For each table in the mdb I need to upload any data to the same table in the backend. To make the whole thing open-ended I want to query for all column identifiers in the back-end table so that I can build my INSERT statements dynamically. I seem to remember doing this on some SQL course yonks ago but can't remember for the life of me how it worked!
any ideas, chaps?
any ideas, chaps?