1

Tables The above image shows the table that I have created in postgresql. Say if I create an account saying 'entertainment' and add 40 entries to it over a month before realizing that I spelt it as entertainmunt. so now, you'd want to rename that account, right? With this table structure..

how should achieve that?

lilly
  • 11
  • 1
  • Have a look at [this](https://stackoverflow.com/questions/38103781/how-to-do-a-cascading-update) SO thread. It is almost identical to your question. – Stefanov.sm Dec 07 '21 at 13:47
  • In your Account table, add an ID column with integer, or probably SERIAL, to have a better PK, than text based Account name, which as you suspect can change or get corrected over time. – Anand Sowmithiran Dec 07 '21 at 18:28

0 Answers0