I have an FME-workbench, and eventually I want my data to be stored in a postgreSQL database. This works perfectly fine with the PostgreSQL-writer.
However, I need to populate multiple tables which underlie several constraints. Thus, the order of when what reader is run, matters.
Moreover, I would like to instantly read the written data for further manipulation (my DB automatically generates an ID (by a sequence) which I need to merge to other tables as a foreign key before writing those tables to my DB).
Any help much appreciated!