"Iavor Raytchev" <[EMAIL PROTECTED]> writes: > The problem we face is -
> When we start to import - the triggers are executed - which must not happen. We > found a way to turn the triggers off for the time of import and then turn them on > after the import. However we can turn the triggers off only per table - so we need > the list of tables, but we have not found a reliable way to get it. We can get them > from the pg_ system tables - but this means if there is a change in them in next > version - we need to change our software, which is not very desirable. It sounds to me like you have reinvented pg_dump ... and not done it very well. Why don't you just use pg_dump? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])