My table name 'Transaction'.

I renamed the table name as 'Transaction_backup' and I have created a new Table 'Transaction'.

When I renamed the old table, the table reference in view also changed into 'Transaction_backup'.

Here, I don't want to change the view reference. I found some answers from Postgresql Rename Table without Updating View Definitions.

It's not possible to 'Create or Replace' all the views.

Is there any other option to rename table without changing view reference?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.