Postgres Views
Jump to navigation
Jump to search
SECURITY INVOKER indicates that the function is to be executed with the privileges of the user that calls it. That is the default. SECURITY DEFINER specifies that the function is to be executed with the privileges of the user that created it.
https://hevodata.com/learn/postgresql-stored-procedures/
CREATE TABLE users.chat as SELECT * FROM api.chat;