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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
