NAME INSERT - create new rows in a table SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO ... column_name [, ...] ) = ( sub-SELECT ) } [, ...] [ WHERE condition ] DES…name [ AS { PERMISSIVE | RESTRICTIVE } ] [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ] [ TO { role_name | PUBLIC | CURRENT ... policy grants the permission to select, insert,…NAME MERGE - conditionally insert, update, or delete rows of a table SYNOPSIS [ WITH with_query ... MATCHED [ BY TARGET ] [ AND condition ] THEN { merge_insert | DO NOTHING } } and…arguments ) where event can be one of: INSERT UPDATE [ OF column_name [, ... ] ] DELETE TRUNCATE DESCRIPTION ... before constraints are checked and the INSERT , UPDATE , or DELETE …updated rows must satisfy for an insert or update operation to succeed. A constraint ... updated rows must satisfy for an insert or update operation to succeed. Expressions evaluat…updatable views. When this option is specified, INSERT , UPDATE , and MERGE commands on the view ... CHECK OPTION is not specified, INSERT , UPDATE , and MERGE commands on the view…list of operations. The allowed operations are insert, update, delete, and truncate. The default ... default value for this option is 'insert, update, delete, truncate'. This param…constant or expression to compute and insert at the indicated place in the resulting table ... appearing at the top level of an INSERT , an expression can be replaced by DEFAULTcommands executed after it was established: BEGIN; INSERT INTO table1 VALUES (1); SAVEPOINT my_savepoint ... INSERT INTO table1 VALUES (2); ROLLBACK TO SAVEPOINT my_savepoint; INSE…where event can be one of: SELECT | INSERT | UPDATE | DELETE DESCRIPTION CREATE RULE defines ... updatable view by defining ON INSERT, ON UPDATE, and ON DELETE rules (or any subsetstandard. EXAMPLES To rename the procedure insert_data with two arguments of type integer ... insert_record: ALTER PROCEDURE insert_data(integer, integer) RENAME TO insert_record; …establish and later release a savepoint: BEGIN; INSERT INTO table1 VALUES (3); SAVEPOINT my_savepoint ... INSERT INTO table1 VALUES (4); RELEASE SAVEPOINT my_savepoint; COMMIT; The…GRANT - define access privileges SYNOPSIS GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN ... OPTION ] [ GRANTED BY role_specification ] GR…execute a procedure. EXAMPLES CREATE PROCEDURE insert_data(a integer, b integer) LANGUAGE ... INSERT INTO tbl VALUES (a); INSERT INTO tbl VALUES (b); $$; or CREATE PROCEDURE insert…will be copied. query A SELECT , VALUES , INSERT , UPDATE , DELETE , or MERGE command whose results ... parentheses are required around the query. For INSERT , UPDATE , DELETE , an…default value will only apply in subsequent INSERT or UPDATE commands; it does not cause ... forms only affect the behavior of subsequent INSERT and UPDATE commands; they do not ca…revoke is one of: GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } [, ...] | ALL [ PRIVILEGES ... GRANT OPTION ] REVOKE [ GRANT OPTION FOR…column_name [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( select | values | insert | update | delete | merge ) [ SEARCH { BREADTH | DEPTH } FIRST ... subquery can be a SELECT , TABLE ,…privileges SYNOPSIS REVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN ... CASCADE | RESTRICT ] REVOKE [ GRANT OPTION FO…replicates tables in the publications mypublication and insert_only and starts replicating immediately on commit ... user=foo dbname=foodb' PUBLICATION mypublication, insert_only; …