V
V
Vladimir Golub2018-02-22 17:22:43
PostgreSQL
Vladimir Golub, 2018-02-22 17:22:43

How to enter data in views?

Description of the problem: there is a database in it several schemas. I use postgres to interact with the application.
When configured, only one schema is specified. I found that to solve this problem, you need to create a scheme in which to create all the necessary views and already work with it. Created, I receive the data.
But I also need to enter data into the database? How to be? Entering data into views is not possible. And the table in which it is necessary to bring the data to be in other scheme.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Shitskov, 2018-02-22
@Zarom

Two conflicting questions for you:

  1. Why did you use views (and put them in a separate schema) if you knew that you would not be limited to reading?
  2. Why can't you read data from one schema and write data to another schema?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question