Difference between revisions of "Postgres Views"
Jump to navigation
Jump to search
(Created page with "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...") |
|||
| Line 3: | Line 3: | ||
https://hevodata.com/learn/postgresql-stored-procedures/ | https://hevodata.com/learn/postgresql-stored-procedures/ | ||
| + | |||
| + | |||
| + | CREATE TABLE users.chat as SELECT * FROM api.chat; | ||
Revision as of 16:29, 19 February 2024
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;