{"id":2952,"date":"2021-07-21T09:54:27","date_gmt":"2021-07-21T09:54:27","guid":{"rendered":"https:\/\/www.bearloga.space\/?page_id=2952"},"modified":"2021-07-21T09:54:27","modified_gmt":"2021-07-21T09:54:27","slug":"postgresql-sintaksis","status":"publish","type":"page","link":"https:\/\/www.bearloga.space\/en\/postgresql-sintaksis\/","title":{"rendered":"PostgreSQL \u2014 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u0412 \u044d\u0442\u043e\u0439 \u0433\u043b\u0430\u0432\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d \u0441\u043f\u0438\u0441\u043e\u043a \u043a\u043e\u043c\u0430\u043d\u0434 PostgreSQL SQL, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0442\u043e\u0447\u043d\u044b\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u0430 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0430 \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0438\u0437 \u044d\u0442\u0438\u0445 \u043a\u043e\u043c\u0430\u043d\u0434.&nbsp;\u042d\u0442\u043e\u0442 \u043d\u0430\u0431\u043e\u0440 \u043a\u043e\u043c\u0430\u043d\u0434 \u0432\u0437\u044f\u0442 \u0438\u0437 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438 psql.&nbsp;\u0422\u0435\u043f\u0435\u0440\u044c, \u043a\u043e\u0433\u0434\u0430 \u0443 \u0432\u0430\u0441 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d Postgres, \u043e\u0442\u043a\u0440\u043e\u0439\u0442\u0435 psql \u043a\u0430\u043a \u2014<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u044b\u0435 \u0444\u0430\u0439\u043b\u044b \u2192 PostgreSQL 9.2 \u2192 \u041e\u0431\u043e\u043b\u043e\u0447\u043a\u0430 SQL (psql).<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f psql, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043f\u043e\u043b\u043d\u044b\u0439 \u0441\u043f\u0438\u0441\u043e\u043a \u043a\u043e\u043c\u0430\u043d\u0434 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043a\u043e\u043c\u0430\u043d\u0434\u044b \\ help.&nbsp;\u0414\u043b\u044f \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0430 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u043e\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0443\u044e \u043a\u043e\u043c\u0430\u043d\u0434\u0443 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> postgres-# \\help &lt;command_name&gt;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 SQL \u0441\u043e\u0441\u0442\u043e\u0438\u0442 \u0438\u0437 \u0442\u043e\u043a\u0435\u043d\u043e\u0432, \u0433\u0434\u0435 \u043a\u0430\u0436\u0434\u044b\u0439 \u0442\u043e\u043a\u0435\u043d \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0442\u044c \u0441\u043e\u0431\u043e\u0439 \u043a\u043b\u044e\u0447\u0435\u0432\u043e\u0435 \u0441\u043b\u043e\u0432\u043e, \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440, \u0437\u0430\u043a\u043b\u044e\u0447\u0435\u043d\u043d\u044b\u0439 \u0432 \u043a\u0430\u0432\u044b\u0447\u043a\u0438 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440, \u043a\u043e\u043d\u0441\u0442\u0430\u043d\u0442\u0443 \u0438\u043b\u0438 \u0441\u0438\u043c\u0432\u043e\u043b \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0438\u043c\u0432\u043e\u043b\u0430.&nbsp;\u0412 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u0439 \u043d\u0438\u0436\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0441\u0442\u0430\u044f \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f SELECT, \u0447\u0442\u043e\u0431\u044b \u043f\u0440\u043e\u0438\u043b\u043b\u044e\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0431\u0430\u0437\u043e\u0432\u0443\u044e, \u043d\u043e \u043f\u043e\u043b\u043d\u0443\u044e \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044e SQL \u0438 \u0435\u0435 \u043a\u043e\u043c\u043f\u043e\u043d\u0435\u043d\u0442\u044b.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th><\/th><th>\u0412\u042b\u0411\u0420\u0410\u0422\u042c<\/th><th>\u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440, \u0438\u043c\u044f<\/th><th>\u041e\u0422<\/th><th>\u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u044f<\/th><\/tr><tr><td>\u0422\u0438\u043f \u0442\u043e\u043a\u0435\u043d\u0430<\/td><td>\u041a\u043b\u044e\u0447\u0435\u0432\u043e\u0435 \u0441\u043b\u043e\u0432\u043e<\/td><td>\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u044b<\/td><td>\u041a\u043b\u044e\u0447\u0435\u0432\u043e\u0435 \u0441\u043b\u043e\u0432\u043e<\/td><td>\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440<\/td><\/tr><tr><td>\u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435<\/td><td>\u043a\u043e\u043c\u0430\u043d\u0434\u0430<\/td><td>\u0421\u0442\u043e\u043b\u0431\u0446\u044b \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u0430 \u0438 \u0438\u043c\u0435\u043d\u0438<\/td><td>\u043f\u0443\u043d\u043a\u0442<\/td><td>\u0418\u043c\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">SQL-\u043a\u043e\u043c\u0430\u043d\u0434\u044b PostgreSQL<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">ABORT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0435\u0440\u0432\u0430\u0442\u044c \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ABORT [ WORK | TRANSACTION ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER AGGREGATE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0430\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER AGGREGATE name ( type ) RENAME TO new_name\nALTER AGGREGATE name ( type ) OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0410\u041b\u042c\u0422\u0415\u0420 \u041a\u041e\u041d\u0412\u0415\u0420\u0421\u0418\u042f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043a\u043e\u043d\u0432\u0435\u0440\u0441\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER CONVERSION name RENAME TO new_name\nALTER CONVERSION name OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER DATABASE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT }\nALTER DATABASE name RESET parameter\nALTER DATABASE name RENAME TO new_name\nALTER DATABASE name OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER DOMAIN<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u043e\u0433\u043e \u0434\u043b\u044f \u0434\u043e\u043c\u0435\u043d\u0430 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT }\nALTER DOMAIN name { SET | DROP } NOT NULL\nALTER DOMAIN name ADD domain_constraint\nALTER DOMAIN name DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]\nALTER DOMAIN name OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER FUNCTION<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO new_name\nALTER FUNCTION name ( [ type [, ...] ] ) OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER GROUP<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER GROUP groupname ADD USER username [, ... ]\nALTER GROUP groupname DROP USER username [, ... ]\nALTER GROUP groupname RENAME TO new_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER INDEX<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0438\u043d\u0434\u0435\u043a\u0441\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER INDEX name OWNER TO new_owner\nALTER INDEX name SET TABLESPACE indexspace_name\nALTER INDEX name RENAME TO new_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0410\u041b\u042c\u0422\u0415\u0420\u0421\u041a\u0418\u0419 \u042f\u0417\u042b\u041a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u043d\u043e\u0433\u043e \u044f\u0437\u044b\u043a\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER LANGUAGE name RENAME TO new_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER OPERATOR<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER OPERATOR name ( { lefttype | NONE }, { righttype | NONE } )\nOWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420 \u041a\u041b\u0410\u0421\u0421<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043a\u043b\u0430\u0441\u0441\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER OPERATOR CLASS name USING index_method RENAME TO new_name\nALTER OPERATOR CLASS name USING index_method OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER SCHEMA<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0441\u0445\u0435\u043c\u044b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER SCHEMA name RENAME TO new_name\nALTER SCHEMA name OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER SEQUENCE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0433\u0435\u043d\u0435\u0440\u0430\u0442\u043e\u0440\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]\n[ MINVALUE minvalue | NO MINVALUE ]\n[ MAXVALUE maxvalue | NO MAXVALUE ]\n[ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER TABLE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE [ ONLY ] name [ * ]\naction [, ... ]\nALTER TABLE [ ONLY ] name [ * ]\nRENAME [ COLUMN ] column TO new_column\nALTER TABLE name\nRENAME TO new_name<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435<\/em>&nbsp;\u2014 \u043e\u0434\u043d\u0430 \u0438\u0437 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0445 \u0441\u0442\u0440\u043e\u043a \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ADD [ COLUMN ] column_type [ column_constraint [ ... ] ]\nDROP [ COLUMN ] column [ RESTRICT | CASCADE ]\nALTER [ COLUMN ] column TYPE type [ USING expression ]\nALTER [ COLUMN ] column SET DEFAULT expression\nALTER [ COLUMN ] column DROP DEFAULT\nALTER [ COLUMN ] column { SET | DROP } NOT NULL\nALTER [ COLUMN ] column SET STATISTICS integer\nALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }\nADD table_constraint\nDROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]\nCLUSTER ON index_name\nSET WITHOUT CLUSTER\nSET WITHOUT OIDS\nOWNER TO new_owner\nSET TABLESPACE tablespace_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER TABLESPACE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0441\u0442\u0432\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLESPACE name RENAME TO new_name\nALTER TABLESPACE name OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER TRIGGER<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TRIGGER name ON table RENAME TO new_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER TYPE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0438\u043f\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TYPE name OWNER TO new_owner<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ALTER USER<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0443\u0447\u0435\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER USER name [ [ WITH ] option [ ... ] ]\nALTER USER name RENAME TO new_name\nALTER USER name SET parameter { TO | = } { value | DEFAULT }\nALTER USER name RESET parameter<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u0432\u0430\u0440\u0438\u0430\u043d\u0442<\/em>&nbsp;\u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n| CREATEDB | NOCREATEDB\n| CREATEUSER | NOCREATEUSER\n| VALID UNTIL 'abstime'<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u0420\u041e\u0410\u041d\u0410\u041b\u0418\u0417\u0418\u0420\u0423\u0419\u0422\u0415<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u0431\u043e\u0440 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0438 \u043e \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041d\u0410\u0427\u0410\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0430\u0447\u0430\u0442\u044c \u0431\u043b\u043e\u043a \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f_\u043c\u043e\u0434<\/em>&nbsp;\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ISOLATION LEVEL { \n   SERIALIZABLE | REPEATABLE READ | READ COMMITTED\n   | READ UNCOMMITTED\n}\nREAD WRITE | READ ONLY<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u041e\u041d\u0422\u0420\u041e\u041b\u042c\u041d\u041e-\u041f\u0420\u041e\u041f\u0423\u0421\u041a\u041d\u041e\u0419 \u041f\u0423\u041d\u041a\u0422<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0438\u043d\u0443\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044c\u043d\u0443\u044e \u0442\u043e\u0447\u043a\u0443 \u0436\u0443\u0440\u043d\u0430\u043b\u0430 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CHECKPOINT<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0411\u041b\u0418\u0417\u041a\u041e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u0430\u043a\u0440\u043e\u0439\u0442\u0435 \u043a\u0443\u0440\u0441\u043e\u0440.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CLOSE name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u043b\u0430\u0441\u0442\u0435\u0440<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u0433\u0440\u0443\u043f\u043f\u0438\u0440\u0443\u0439\u0442\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0432 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 \u0441 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u043c.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CLUSTER index_name ON table_name\nCLUSTER table_name\nCLUSTER<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u041e\u041c\u041c\u0415\u041d\u0422\u0410\u0420\u0418\u0419<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u0438\u043b\u0438 \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u043e\u0431\u044a\u0435\u043a\u0442\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">COMMENT ON {\n   TABLE object_name |\n   COLUMN table_name.column_name |\n   AGGREGATE agg_name (agg_type) |\n   CAST (source_type AS target_type) |\n   CONSTRAINT constraint_name ON table_name |\n   CONVERSION object_name |\n   DATABASE object_name |\n   DOMAIN object_name |\n   FUNCTION func_name (arg1_type, arg2_type, ...) |\n   INDEX object_name |\n   LARGE OBJECT large_object_oid |\n   OPERATOR op (left_operand_type, right_operand_type) |\n   OPERATOR CLASS object_name USING index_method |\n   [ PROCEDURAL ] LANGUAGE object_name |\n   RULE rule_name ON table_name |\n   SCHEMA object_name |\n   SEQUENCE object_name |\n   TRIGGER trigger_name ON table_name |\n   TYPE object_name |\n   VIEW object_name\n} \nIS 'text'<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">COMMIT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u0443\u0439\u0442\u0435 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">COMMIT [ WORK | TRANSACTION ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">COPY<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043a\u043e\u043f\u0438\u0440\u0443\u0439\u0442\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043c\u0435\u0436\u0434\u0443 \u0444\u0430\u0439\u043b\u043e\u043c \u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0435\u0439.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">COPY table_name [ ( column [, ...] ) ]\nFROM { 'filename' | STDIN }\n[ WITH ]\n[ BINARY ]\n[ OIDS ]\n[ DELIMITER [ AS ] 'delimiter' ]\n[ NULL [ AS ] 'null string' ]\n[ CSV [ QUOTE [ AS ] 'quote' ]\n[ ESCAPE [ AS ] 'escape' ]\n[ FORCE NOT NULL column [, ...] ]\nCOPY table_name [ ( column [, ...] ) ]\nTO { 'filename' | STDOUT }\n[ [ WITH ]\n[ BINARY ]\n[ OIDS ]\n[ DELIMITER [ AS ] 'delimiter' ]\n[ NULL [ AS ] 'null string' ]\n[ CSV [ QUOTE [ AS ] 'quote' ]\n[ ESCAPE [ AS ] 'escape' ]\n[ FORCE QUOTE column [, ...] ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0410\u0413\u0420\u0415\u0413\u0410\u0422<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0430\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE AGGREGATE name (\n   BASETYPE = input_data_type,\n   SFUNC = sfunc,\n   STYPE = state_data_type\n   [, FINALFUNC = ffunc ]\n   [, INITCOND = initial_condition ]\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0410\u041a\u0422\u0415\u0420\u042b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0441\u043e\u0441\u0442\u0430\u0432.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE CAST (source_type AS target_type)\nWITH FUNCTION func_name (arg_types)\n[ AS ASSIGNMENT | AS IMPLICIT ]\nCREATE CAST (source_type AS target_type)\nWITHOUT FUNCTION\n[ AS ASSIGNMENT | AS IMPLICIT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041e\u0413\u0420\u0410\u041d\u0418\u0427\u0415\u041d\u041d\u042b\u0419 \u0422\u0420\u0418\u0413\u0413\u0415\u0420<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0442\u0440\u0438\u0433\u0433\u0435\u0440 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE CONSTRAINT TRIGGER name\nAFTER events ON\ntable_name constraint attributes\nFOR EACH ROW EXECUTE PROCEDURE func_name ( args )<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041a\u041e\u041d\u0412\u0415\u0420\u0421\u0418\u042f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u043a\u043e\u043d\u0432\u0435\u0440\u0441\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [DEFAULT] CONVERSION name\nFOR source_encoding TO dest_encoding FROM func_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0411\u0410\u0417\u0423 \u0414\u0410\u041d\u041d\u042b\u0425<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE DATABASE name\n[ [ WITH ] [ OWNER [=] db_owner ]\n   [ TEMPLATE [=] template ]\n   [ ENCODING [=] encoding ]\n   [ TABLESPACE [=] tablespace ] \n]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0414\u041e\u041c\u0415\u041d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0434\u043e\u043c\u0435\u043d.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE DOMAIN name [AS] data_type\n[ DEFAULT expression ]\n[ constraint [ ... ] ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435<\/em>&nbsp;\u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[ CONSTRAINT constraint_name ]\n{ NOT NULL | NULL | CHECK (expression) }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0424\u0423\u041d\u041a\u0426\u0418\u042e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ OR REPLACE ] FUNCTION name ( [ [ arg_name ] arg_type [, ...] ] )\nRETURNS ret_type\n{ LANGUAGE lang_name\n   | IMMUTABLE | STABLE | VOLATILE\n   | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n   | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n   | AS 'definition'\n   | AS 'obj_file', 'link_symbol'\n} ...\n[ WITH ( attribute [, ...] ) ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0413\u0420\u0423\u041f\u041f\u0423<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0433\u0440\u0443\u043f\u043f\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE GROUP name [ [ WITH ] option [ ... ] ]\nWhere option can be:\nSYSID gid\n| USER username [, ...]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0418\u041d\u0414\u0415\u041a\u0421<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0438\u043d\u0434\u0435\u043a\u0441.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ UNIQUE ] INDEX name ON table [ USING method ]\n( { column | ( expression ) } [ opclass ] [, ...] )\n[ TABLESPACE tablespace ]\n[ WHERE predicate ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u042f\u0417\u042b\u041a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u043d\u044b\u0439 \u044f\u0437\u044b\u043a.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name\nHANDLER call_handler [ VALIDATOR val_function ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u043e\u0433\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE OPERATOR name (\n   PROCEDURE = func_name\n   [, LEFTARG = left_type ] [, RIGHTARG = right_type ]\n   [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]\n   [, RESTRICT = res_proc ] [, JOIN = join_proc ]\n   [, HASHES ] [, MERGES ]\n   [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ]\n   [, LTCMP = less_than_op ] [, GTCMP = greater_than_op ]\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041a\u041b\u0410\u0421\u0421 \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420\u0410<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u043a\u043b\u0430\u0441\u0441 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u0432.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type\nUSING index_method AS\n{ OPERATOR strategy_number operator_name [ ( op_type, op_type ) ] [ RECHECK ]\n   | FUNCTION support_number func_name ( argument_type [, ...] )\n   | STORAGE storage_type\n} [, ... ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041f\u0420\u0410\u0412\u0418\u041b\u041e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u043e\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0438\u0441\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ OR REPLACE ] RULE name AS ON event\nTO table [ WHERE condition ]\nDO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0421\u0425\u0415\u041c\u0423<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0441\u0445\u0435\u043c\u0443.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE SCHEMA schema_name\n[ AUTHORIZATION username ] [ schema_element [ ... ] ]\nCREATE SCHEMA AUTHORIZATION username\n[ schema_element [ ... ] ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041f\u041e\u0421\u041b\u0415\u0414\u041e\u0412\u0410\u0422\u0415\u041b\u042c\u041d\u041e\u0421\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0433\u0435\u043d\u0435\u0440\u0430\u0442\u043e\u0440 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ TEMPORARY | TEMP ] SEQUENCE name\n[ INCREMENT [ BY ] increment ]\n[ MINVALUE minvalue | NO MINVALUE ]\n[ MAXVALUE maxvalue | NO MAXVALUE ]\n[ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0421\u0422\u041e\u041b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ [ GLOBAL | LOCAL ] { \n   TEMPORARY | TEMP } ] TABLE table_name ( { \n      column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]\n      | table_constraint\n      | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] \n   } [, ... ]\n)\n[ INHERITS ( parent_table [, ... ] ) ]\n[ WITH OIDS | WITHOUT OIDS ]\n[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n[ TABLESPACE tablespace ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435 \u043d\u0430\u0445\u043e\u0434\u0438\u0442\u0441\u044f&nbsp;<em>column_constraint<\/em>&nbsp;\u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[ CONSTRAINT constraint_name ] { \n   NOT NULL |\n   NULL |\n   UNIQUE [ USING INDEX TABLESPACE tablespace ] |\n   PRIMARY KEY [ USING INDEX TABLESPACE tablespace ] |\n   CHECK (expression) |\n   REFERENCES ref_table [ ( ref_column ) ]\n   [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n   [ ON DELETE action ] [ ON UPDATE action ] \n}\n[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418&nbsp;<em>\u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/em>&nbsp;\u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[ CONSTRAINT constraint_name ]\n{ UNIQUE ( column_name [, ... ] ) [ USING INDEX TABLESPACE tablespace ] |\nPRIMARY KEY ( column_name [, ... ] ) [ USING INDEX TABLESPACE tablespace ] |\nCHECK ( expression ) |\nFOREIGN KEY ( column_name [, ... ] )\nREFERENCES ref_table [ ( ref_column [, ... ] ) ]\n[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n[ ON DELETE action ] [ ON UPDATE action ] }\n[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0422\u0410\u0411\u041b\u0418\u0426\u0423 \u041a\u0410\u041a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name\n[ (column_name [, ...] ) ] [ [ WITH | WITHOUT ] OIDS ]\nAS query<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0421\u0422\u041e\u041b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u043e\u0435 \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u043e\u0435 \u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0441\u0442\u0432\u043e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLESPACE tablespace_name [ OWNER username ] LOCATION 'directory'<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0422\u0420\u0418\u0413\u0413\u0415\u0420<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0442\u0440\u0438\u0433\u0433\u0435\u0440.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] }\nON table [ FOR [ EACH ] { ROW | STATEMENT } ]\nEXECUTE PROCEDURE func_name ( arguments )<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0422\u0418\u041f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0442\u0438\u043f \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TYPE name AS\n( attribute_name data_type [, ... ] )\nCREATE TYPE name (\nINPUT = input_function,\nOUTPUT = output_function\n[, RECEIVE = receive_function ]\n[, SEND = send_function ]\n[, ANALYZE = analyze_function ]\n[, INTERNALLENGTH = { internal_length | VARIABLE } ]\n[, PASSEDBYVALUE ]\n[, ALIGNMENT = alignment ]\n[, STORAGE = storage ]\n[, DEFAULT = default ]\n[, ELEMENT = element ]\n[, DELIMITER = delimiter ]\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u041f\u041e\u041b\u042c\u0417\u041e\u0412\u0410\u0422\u0415\u041b\u042f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0443\u0447\u0435\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER name [ [ WITH ] option [ ... ] ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u0432\u0430\u0440\u0438\u0430\u043d\u0442<\/em>&nbsp;\u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SYSID uid\n| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n| CREATEDB | NOCREATEDB\n| CREATEUSER | NOCREATEUSER\n| IN GROUP group_name [, ...]\n| VALID UNTIL 'abs_time'<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041e\u0417\u0414\u0410\u0422\u042c \u0412\u0418\u0414<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u044c \u043d\u043e\u0432\u044b\u0439 \u0432\u0438\u0434.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ] AS query<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DEALLOCATE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0420\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u043e\u0435 \u0437\u0430\u044f\u0432\u043b\u0435\u043d\u0438\u0435.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DEALLOCATE [ PREPARE ] plan_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DECLARE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u044c \u043a\u0443\u0440\u0441\u043e\u0440.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DECLARE name [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ]\nCURSOR [ { WITH | WITHOUT } HOLD ] FOR query\n[ FOR { READ ONLY | UPDATE [ OF column [, ...] ] } ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0423\u0414\u0410\u041b\u042f\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM [ ONLY ] table [ WHERE condition ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP AGGREGATE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u0410\u041f\u041b\u0418 \u041a\u0410\u041f\u0418\u0422\u0410\u041b\u0410<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u043a\u0442\u0435\u0440\u0441\u043a\u0438\u0439 \u0441\u043e\u0441\u0442\u0430\u0432.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP CAST (source_type AS target_type) [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u0410\u041f\u041b\u0418\u0412\u041d\u0410\u042f \u041a\u041e\u041d\u0412\u0415\u0420\u0421\u0418\u042f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043a\u043e\u043d\u0432\u0435\u0440\u0441\u0438\u044e<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP CONVERSION name [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP DATABASE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP DATABASE name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP DOMAIN<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0434\u043e\u043c\u0435\u043d.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP DOMAIN name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0424\u0423\u041d\u041a\u0426\u0418\u042f \u041a\u0410\u041f\u041b\u0418<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0444\u0443\u043d\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP GROUP<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP GROUP name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0418\u043d\u0434\u0435\u043a\u0441 \u043a\u0430\u043f\u043b\u0438<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0438\u043d\u0434\u0435\u043a\u0441.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP INDEX name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0423\u0421\u0422\u0410\u0420\u0415\u0422\u042c \u042f\u0417\u042b\u041a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u043d\u044b\u0439 \u044f\u0437\u044b\u043a.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u0410\u041f\u0415\u041b\u042c\u041d\u042b\u0419 \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP OPERATOR name ( { left_type | NONE }, { right_type | NONE } )\n[ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u0410\u041f\u041b\u042f\u0416 \u041e\u041f\u0415\u0420\u0410\u0422\u041e\u0420\u0410<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043a\u043b\u0430\u0441\u0441 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP OPERATOR CLASS name USING index_method [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP RULE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043f\u0440\u0430\u0432\u0438\u043b\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0438\u0441\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP RULE name ON relation [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP SCHEMA<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0441\u0445\u0435\u043c\u0443.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP SCHEMA name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP SEQUENCE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP TABLE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0441\u0442\u043e\u043b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP TABLE name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP TABLESPACE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0447\u043d\u043e\u0435 \u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0441\u0442\u0432\u043e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP TABLESPACE tablespace_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP TRIGGER<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0442\u0440\u0438\u0433\u0433\u0435\u0440.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP TRIGGER name ON table [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP TYPE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0442\u0438\u043f \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP TYPE name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP USER<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0443\u0447\u0435\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP USER name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DROP VIEW<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u0432\u0438\u0434.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DROP VIEW name [, ...] [ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u041e\u041d\u0415\u0426<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u0430\u0444\u0438\u043a\u0441\u0438\u0440\u0443\u0439\u0442\u0435 \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">END [ WORK | TRANSACTION ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0412\u042b\u041f\u041e\u041b\u041d\u0418\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0412\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u043e\u0435 \u0437\u0430\u044f\u0432\u043b\u0435\u043d\u0438\u0435.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">EXECUTE plan_name [ (parameter [, ...] ) ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">EXPLAIN<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u043f\u043b\u0430\u043d \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0432\u044b\u043f\u0438\u0441\u043a\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">EXPLAIN [ ANALYZE ] [ VERBOSE ] statement<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">FETCH<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438 \u0438\u0437 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043a\u0443\u0440\u0441\u043e\u0440\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">FETCH [ direction { FROM | IN } ] cursor_name<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435<\/em>&nbsp;\u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0443\u0441\u0442\u044b\u043c \u0438\u043b\u0438 \u043e\u0434\u043d\u043e \u0438\u0437 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">NEXT\nPRIOR\nFIRST\nLAST\nABSOLUTE count\nRELATIVE count\ncount\nALL\nFORWARD\nFORWARD count\nFORWARD ALL\nBACKWARD\nBACKWARD count\nBACKWARD ALL<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0413\u0420\u0410\u041d\u0422<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }\n[,...] | ALL [ PRIVILEGES ] }\nON [ TABLE ] table_name [, ...]\nTO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }\nON DATABASE db_name [, ...]\nTO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { CREATE | ALL [ PRIVILEGES ] }\nON TABLESPACE tablespace_name [, ...]\nTO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { EXECUTE | ALL [ PRIVILEGES ] }\nON FUNCTION func_name ([type, ...]) [, ...]\nTO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { USAGE | ALL [ PRIVILEGES ] }\nON LANGUAGE lang_name [, ...]\nTO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n\nGRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }\nON SCHEMA schema_name [, ...]\nTO { username | GROUP group_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0412\u0421\u0422\u0410\u0412\u0418\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u043e\u0432\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">INSERT INTO table [ ( column [, ...] ) ]\n{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | query }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u041b\u0423\u0428\u0410\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043b\u0443\u0448\u0430\u0439\u0442\u0435 \u0443\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">LISTEN name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041d\u0410\u0413\u0420\u0423\u0417\u041a\u0418<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0435 \u0438\u043b\u0438 \u043f\u0435\u0440\u0435\u0437\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0435 \u0444\u0430\u0439\u043b \u043e\u0431\u0449\u0435\u0439 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">LOAD 'filename'<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0417\u0410\u041c\u041e\u041a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u0430\u0431\u043b\u043e\u043a\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u0442\u043e\u043b<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">LOCK [ TABLE ] name [, ...] [ IN lock_mode MODE ] [ NOWAIT ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>lock_mode<\/em>&nbsp;\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE\n| SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u0415\u0420\u0415\u0415\u0425\u0410\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u043c\u0435\u0441\u0442\u0438\u0442\u0435 \u043a\u0443\u0440\u0441\u043e\u0440.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">MOVE [ direction { FROM | IN } ] cursor_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u041e\u0421\u0422\u0410\u0412\u0418\u0422\u042c \u0412 \u0418\u0417\u0412\u0415\u0421\u0422\u041d\u041e\u0421\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043e\u0437\u0434\u0430\u0442\u044c \u0443\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u0435.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">NOTIFY name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u041e\u0414\u0413\u041e\u0422\u041e\u0412\u0418\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u044c\u0442\u0435 \u0437\u0430\u044f\u0432\u043b\u0435\u043d\u0438\u0435 \u043a \u0438\u0441\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">PREPARE plan_name [ (data_type [, ...] ) ] AS statement<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">REINDEX<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0435\u0440\u0435\u0441\u0442\u0440\u043e\u0439\u0442\u0435 \u0438\u043d\u0434\u0435\u043a\u0441\u044b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">REINDEX { DATABASE | TABLE | INDEX } name [ FORCE ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">RELEASE SAVEPOINT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u043d\u0438\u0447\u0442\u043e\u0436\u0438\u0442\u044c \u0440\u0430\u043d\u0435\u0435 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u0443\u044e \u0442\u043e\u0447\u043a\u0443 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">RELEASE [ SAVEPOINT ] savepoint_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u0411\u0420\u041e\u0421<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0412\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0434\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">RESET name\nRESET ALL<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041a\u0415\u0423\u041e\u041a\u0415<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0434\u0430\u043b\u0438\u0442\u044c \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">REVOKE [ GRANT OPTION FOR ]\n{ { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }\n[,...] | ALL [ PRIVILEGES ] }\nON [ TABLE ] table_name [, ...]\nFROM { username | GROUP group_name | PUBLIC } [, ...]\n[ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n{ { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }\nON DATABASE db_name [, ...]\nFROM { username | GROUP group_name | PUBLIC } [, ...]\n[ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n{ CREATE | ALL [ PRIVILEGES ] }\nON TABLESPACE tablespace_name [, ...]\nFROM { username | GROUP group_name | PUBLIC } [, ...]\n[ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n{ EXECUTE | ALL [ PRIVILEGES ] }\nON FUNCTION func_name ([type, ...]) [, ...]\nFROM { username | GROUP group_name | PUBLIC } [, ...]\n[ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n{ USAGE | ALL [ PRIVILEGES ] }\nON LANGUAGE lang_name [, ...]\nFROM { username | GROUP group_name | PUBLIC } [, ...]\n[ CASCADE | RESTRICT ]\n\nREVOKE [ GRANT OPTION FOR ]\n{ { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }\nON SCHEMA schema_name [, ...]\nFROM { username | GROUP group_name | PUBLIC } [, ...]\n[ CASCADE | RESTRICT ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">ROLLBACK<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0435\u0440\u0432\u0430\u0442\u044c \u0442\u0435\u043a\u0443\u0449\u0443\u044e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044e.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ROLLBACK [ WORK | TRANSACTION ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041e\u0442\u043a\u0430\u0442 \u043a SAVEPOINT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u0442\u043a\u0430\u0442 \u043a \u0442\u043e\u0447\u043a\u0435 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">SAVEPOINT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0442\u043e\u0447\u043a\u0443 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0432 \u0442\u0435\u043a\u0443\u0449\u0435\u0439 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SAVEPOINT savepoint_name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0412\u042b\u0411\u0420\u0410\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0438\u043b\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]\n* | expression [ AS output_name ] [, ...]\n[ FROM from_item [, ...] ]\n[ WHERE condition ]\n[ GROUP BY expression [, ...] ]\n[ HAVING condition [, ...] ]\n[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]\n[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]\n[ LIMIT { count | ALL } ]\n[ OFFSET start ]\n[ FOR UPDATE [ OF table_name [, ...] ] ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>from_item<\/em>&nbsp;\u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043e\u0434\u043d\u0438\u043c \u0438\u0437:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]\n( select ) [ AS ] alias [ ( column_alias [, ...] ) ]\nfunction_name ( [ argument [, ...] ] )\n[ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]\nfunction_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )\nfrom_item [ NATURAL ] join_type from_item\n[ ON join_condition | USING ( join_column [, ...] ) ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0412\u042b\u0411\u0420\u0410\u0422\u042c \u0412<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u0435 \u043d\u043e\u0432\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]\n* | expression [ AS output_name ] [, ...]\nINTO [ TEMPORARY | TEMP ] [ TABLE ] new_table\n[ FROM from_item [, ...] ]\n[ WHERE condition ]\n[ GROUP BY expression [, ...] ]\n[ HAVING condition [, ...] ]\n[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]\n[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]\n[ LIMIT { count | ALL } ]\n[ OFFSET start ]\n[ FOR UPDATE [ OF table_name [, ...] ] ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0417\u0410\u0414\u0410\u0412\u0410\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT }\nSET [ SESSION | LOCAL ] TIME ZONE { time_zone | LOCAL | DEFAULT }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0423\u0421\u0422\u0410\u041d\u041e\u0412\u0418\u0422\u042c \u041e\u0413\u0420\u0410\u041d\u0418\u0427\u0415\u041d\u0418\u042f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0435 \u0440\u0435\u0436\u0438\u043c\u044b \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0442\u0435\u043a\u0443\u0449\u0435\u0439 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0423\u0421\u0422\u0410\u041d\u041e\u0412\u041a\u0410 \u0410\u0412\u0422\u041e\u0420\u0418\u0417\u0410\u0426\u0418\u0418 \u0421\u0415\u0421\u0421\u0418\u0418<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0435 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0441\u0435\u0430\u043d\u0441\u0430 \u0438 \u0442\u0435\u043a\u0443\u0449\u0438\u0439 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0442\u0435\u043a\u0443\u0449\u0435\u0433\u043e \u0441\u0435\u0430\u043d\u0441\u0430.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username\nSET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT\nRESET SESSION AUTHORIZATION<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0423\u0421\u0422\u0410\u041d\u041e\u0412\u0418\u0422\u042c \u0421\u0414\u0415\u041b\u041a\u0423<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0435 \u0445\u0430\u0440\u0430\u043a\u0442\u0435\u0440\u0438\u0441\u0442\u0438\u043a\u0438 \u0442\u0435\u043a\u0443\u0449\u0435\u0439 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SET TRANSACTION transaction_mode [, ...]\nSET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, ...]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f_\u043c\u043e\u0434<\/em>&nbsp;\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED\n| READ UNCOMMITTED }\nREAD WRITE | READ ONLY<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0428\u041e\u0423<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SHOW name\nSHOW ALL<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041d\u0410\u0427\u0410\u0422\u042c \u0421\u0414\u0415\u041b\u041a\u0423<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0430\u0447\u0430\u0442\u044c \u0431\u043b\u043e\u043a \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">START TRANSACTION [ transaction_mode [, ...] ]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0413\u0434\u0435&nbsp;<em>\u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f_\u043c\u043e\u0434<\/em>&nbsp;\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED\n| READ UNCOMMITTED }\nREAD WRITE | READ ONLY<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">TRUNCATE<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0443\u0441\u0442\u043e\u0439 \u0441\u0442\u043e\u043b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">TRUNCATE [ TABLE ] name<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">UNLISTEN<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0425\u0432\u0430\u0442\u0438\u0442 \u0441\u043b\u0443\u0448\u0430\u0442\u044c \u0443\u0432\u0435\u0434\u043e\u043c\u043b\u0435\u043d\u0438\u044f.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UNLISTEN { name | * }<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u041e\u0411\u041d\u041e\u0412\u0418\u0422\u042c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u0431\u043d\u043e\u0432\u0438\u0442\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE [ ONLY ] table SET column = { expression | DEFAULT } [, ...]\n[ FROM from_list ]\n[ WHERE condition ]<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u0412\u0410\u041a\u0423\u0423\u041c\u041d\u0410\u042f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u0431\u043e\u0440\u043a\u0430 \u043c\u0443\u0441\u043e\u0440\u0430 \u0438 \u043f\u0440\u0438 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u0430\u043d\u0430\u043b\u0438\u0437 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0412 \u044d\u0442\u043e\u0439 \u0433\u043b\u0430\u0432\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d \u0441\u043f\u0438\u0441\u043e\u043a \u043a\u043e\u043c\u0430\u043d\u0434 PostgreSQL SQL, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0442\u043e\u0447\u043d\u044b\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u0430 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0430 \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0438\u0437 \u044d\u0442\u0438\u0445 \u043a\u043e\u043c\u0430\u043d\u0434.&nbsp;\u042d\u0442\u043e\u0442 \u043d\u0430\u0431\u043e\u0440 \u043a\u043e\u043c\u0430\u043d\u0434 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[104],"tags":[],"class_list":["post-2952","page","type-page","status-publish","hentry","category-postgresql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/pages\/2952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/comments?post=2952"}],"version-history":[{"count":0,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/pages\/2952\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/media?parent=2952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/categories?post=2952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bearloga.space\/en\/wp-json\/wp\/v2\/tags?post=2952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}