P
P
postgresdev2019-10-11 20:40:47
PostgreSQL
postgresdev, 2019-10-11 20:40:47

How to remove row from table view in Postgresql?

You need to remove the line from the view, I think it could be cached.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2019-10-11
@postgresdev

If materialized view - then refresh materialized view
If not materialized - then it could not be cached. See the definition of view and examine where the row in the result of this query comes from.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question