copy branch of tree in table with REFERENCES

Asked Aug 22 '20 at 12:34

Active Aug 22 '20 at 12:34

Viewed 40 times

I have table with tree data as in this. @Branko Dimitrijevic gave a great answer. But I have other table with foreign key on table with tree data. In my case other table:

CREATE TABLE TT(
  tt_id SERIALPRIMARY KEY,
  tt_value VARCHAR(50),
  t1_id int REFERENCES t1(id)
);

How copy branch with tree data and data in other table?

asked Aug 22 '20 at 12:34

yrichs

What is table `t1` ? Please add sample data and your intended result to your question. – wildplasser Aug 22 '20 at 12:44
you may see this? https://stackoverflow.com/questions/10025154/postgresql-copy-data-within-the-tree-table – yrichs Aug 22 '20 at 13:05
Yes, I even commented on it, eight years ago. – wildplasser Aug 22 '20 at 13:06

copy branch of tree in table with REFERENCES

0 Answers0