Re: copy row tree

Toni Casueps wrote:
>
>
> I have a set of tables with one-to-many relationships between them:
>
> T1 <-->> T2 <-->> T3 <-->> T4
>
> I need to copy some rows of these tables to another set of tables which
> have
> the same fields. There are two rows on T1 that I want to copy, and then
> those rows of T2 linked to the other ones, and so on.
>
> Is there a way to accomplish this? I have pgadminIII, DBManager and EMS
> Postgresql Manager.
>
>

Is there foreign keys constrains between tables T1, T2, T3 and T4 or just
logical relationship?
EMS Postgresql Manager has visual query designer and dependency viewer. Use
it features to select disired records and insert it into second set of
tables. Also
--
View this message in context: http://www.nabble.com/-GENERAL--copy-row-tree-tf3026502.html#a8445042
Sent from the PostgreSQL - general mailing list archive at Nabble.com.