Re: import/export or moving data between databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Iavor Raytchev" <pobox(at)verysmall(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: import/export or moving data between databases
Date: 2004-09-19 16:45:25
Message-ID: 19646.1095612325@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Iavor Raytchev" <pobox(at)verysmall(dot)org> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Iavor Raytchev 2004-09-19 20:55:50 Re: import/export or moving data between databases
Previous Message Tom Lane 2004-09-19 16:31:26 Re: Problem in converting int to timestamp value - why?