pgschema operates at the schema level. This means it does not support SQL commands that operate the non-schema level objects.
Cluster Level Commands
CREATE DATABASE
CREATE ROLE
CREATE TABLESPACE
CREATE USER
Roles stay out of your schema files, but you can still grant to them: plan stubs every role your schema references (GRANT/REVOKE, CREATE POLICY ... TO, ALTER DEFAULT PRIVILEGES FOR ROLE) in its temporary database, provided the role exists on the target database. See Roles.
Database Level Commands
CREATE CAST
CREATE COLLATION
CREATE CONVERSION
CREATE EVENT TRIGGER
CREATE EXTENSION
CREATE FOREIGN DATA WRAPPER
CREATE LANGUAGE
CREATE OPERATOR
CREATE PUBLICATION
CREATE SCHEMA
CREATE SERVER
CREATE SUBSCRIPTION
CREATE TEXT SEARCH
CREATE USER MAPPING
Schema Level Commands
We plan to support most schema-level commands in the future. Please check other sections for the schema-level database objects that we support right now.
Object Ownership
pgschema does not manage which role owns an object. Like pg_dump --no-owner, dump never emits ALTER ... OWNER TO, and plan does not compare owners, so the same schema file stays portable across environments where owners differ.This applies to every OWNER TO form on schema-level objects:
ALTER TABLE ... OWNER TO / ALTER FOREIGN TABLE ... OWNER TO
ALTER INDEX ... OWNER TO
ALTER VIEW ... OWNER TO / ALTER MATERIALIZED VIEW ... OWNER TO
ALTER FUNCTION ... OWNER TO / ALTER PROCEDURE ... OWNER TO
ALTER AGGREGATE ... OWNER TO
ALTER SEQUENCE ... OWNER TO
ALTER TYPE ... OWNER TO / ALTER DOMAIN ... OWNER TO
An OWNER TO statement in your schema files has no effect on the plan. plan and apply print a warning for it and skip it, and the owner on the target database stays as it is. When OWNER TO shares an ALTER TABLE with other actions, only the OWNER TO action is skipped.
Objects created by apply are owned by the role that runs it. To get a specific owner, run apply as that role, or change the owner outside of pgschema:
ALTER TABLE orders OWNER TO app_owner;
Global Default Privileges
ALTER DEFAULT PRIVILEGES is supported only with IN SCHEMA. See ALTER DEFAULT PRIVILEGES.Without IN SCHEMA, the statement sets a default for every schema in the database where the role creates objects. That is database-level state, not part of the schema pgschema manages, and several schemas managed separately would each claim it.
A global ALTER DEFAULT PRIVILEGES statement in your schema files has no effect on the plan. plan and apply print a warning for it and skip it, and the target database is not changed.
Apply global default privileges outside of pgschema, or scope them to the schema:
ALTER DEFAULT PRIVILEGES FOR ROLE app_owner IN SCHEMA public GRANT SELECT ON TABLES TO app_reader;
Rename
RENAME is not supported.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"pgschema, Declarative Schema Migration for Postgres","colors":{"primary":"#F4473C","light":"#FFB1A6","dark":"#CF2F2A"},"logo":{"light":"https://mintcdn.com/pgschema/0WkBUT0FtHZnmbRN/logo/light.png?fit=max\u0026auto=format\u0026n=0WkBUT0FtHZnmbRN\u0026q=85\u0026s=6c255c2bdd005e854bf235c5f89a1384","dark":"https://mintcdn.com/pgschema/0WkBUT0FtHZnmbRN/logo/dark.png?fit=max\u0026auto=format\u0026n=0WkBUT0FtHZnmbRN\u0026q=85\u0026s=8bfb63fa136ad30cae02055b84510316"},"favicon":"https://mintcdn.com/pgschema/0WkBUT0FtHZnmbRN/favicon.ico?fit=max\u0026auto=format\u0026n=0WkBUT0FtHZnmbRN\u0026q=85\u0026s=83335c5e23130e66d218e39829488f9a","navbar":{"primary":{"type":"github","href":"https://github.com/pgplex/pgschema"}},"footer":{"socials":{"github":"https://github.com/pgplex/pgschema"}},"seo":{"metatags":{"canonical":"https://www.pgschema.com"}},"fonts":{"family":"DM Sans"},"integrations":{"plausible":{"domain":"pgschema.com"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity"],"display":"header"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"pgschema","hasAudioNarration":false,"actualSubdomain":"pgschema","customDomains":["www.pgschema.com"],"gitSource":{"type":"github","owner":"pgschema","repo":"pgschema-mintlify","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6aedeb331700a18ffd1cc4fc","clientVersion":"0.0.4227","searchFilterCounts":[{"language":"default","tag":"Docs","count":20},{"language":"default","tag":"Syntax","count":16},{"language":"default","tag":"Workflow","count":9},{"language":"default","tag":"Dev Journal","count":5},{"language":"default","tag":"Getting started","count":5},{"language":"default","tag":"CLI Reference","count":3},{"language":"default","tag":"Configuration","count":3}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[],"googleFontsInlined":true},"customCss":[]}
{"page":{"pagePath":"syntax/unsupported","slug":"/syntax/unsupported","pageMetadata":{"title":"Unsupported","description":null,"href":"/syntax/unsupported"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,p:`p`,pre:`pre`,span:`span`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[_jsx(_components.code,{children:`pgschema`}),` operates at the schema level. This means it does not support SQL commands that operate the non-schema level objects.`]}),`\n`,_jsx(Heading,{level:`2`,id:`cluster-level-commands`,children:`Cluster Level Commands`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE DATABASE`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE ROLE`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE TABLESPACE`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE USER`})}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`Roles stay out of your schema files, but you can still grant to them: `,_jsx(_components.code,{children:`plan`}),` stubs every role your schema references (`,_jsx(_components.code,{children:`GRANT`}),`/`,_jsx(_components.code,{children:`REVOKE`}),`, `,_jsx(_components.code,{children:`CREATE POLICY ... TO`}),`, `,_jsx(_components.code,{children:`ALTER DEFAULT PRIVILEGES FOR ROLE`}),`) in its temporary database, provided the role exists on the target database. See `,_jsx(_components.a,{href:`/cli/plan-db#roles`,children:`Roles`}),`.`]}),`\n`,_jsx(Heading,{level:`2`,id:`database-level-commands`,children:`Database Level Commands`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE CAST`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE COLLATION`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE CONVERSION`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE EVENT TRIGGER`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE EXTENSION`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE FOREIGN DATA WRAPPER`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE LANGUAGE`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE OPERATOR`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE PUBLICATION`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE SCHEMA`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE SERVER`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE SUBSCRIPTION`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE TEXT SEARCH`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`CREATE USER MAPPING`})}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`schema-level-commands`,children:`Schema Level Commands`}),`\n`,_jsx(_components.p,{children:`We plan to support most schema-level commands in the future. Please check other sections for the schema-level database objects that we support right now.`}),`\n`,_jsx(Heading,{level:`2`,id:`object-ownership`,children:`Object Ownership`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`pgschema`}),` does not manage which role owns an object. Like `,_jsx(_components.code,{children:`pg_dump --no-owner`}),`, `,_jsx(_components.code,{children:`dump`}),` never emits `,_jsx(_components.code,{children:`ALTER ... OWNER TO`}),`, and `,_jsx(_components.code,{children:`plan`}),` does not compare owners, so the same schema file stays portable across environments where owners differ.`]}),`\n`,_jsxs(_components.p,{children:[`This applies to every `,_jsx(_components.code,{children:`OWNER TO`}),` form on schema-level objects:`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`ALTER TABLE ... OWNER TO`}),` / `,_jsx(_components.code,{children:`ALTER FOREIGN TABLE ... OWNER TO`})]}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`ALTER INDEX ... OWNER TO`})}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`ALTER VIEW ... OWNER TO`}),` / `,_jsx(_components.code,{children:`ALTER MATERIALIZED VIEW ... OWNER TO`})]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`ALTER FUNCTION ... OWNER TO`}),` / `,_jsx(_components.code,{children:`ALTER PROCEDURE ... OWNER TO`})]}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`ALTER AGGREGATE ... OWNER TO`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`ALTER SEQUENCE ... OWNER TO`})}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.code,{children:`ALTER TYPE ... OWNER TO`}),` / `,_jsx(_components.code,{children:`ALTER DOMAIN ... OWNER TO`})]}),`\n`]}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`An `,_jsx(_components.code,{children:`OWNER TO`}),` statement in your schema files has no effect on the plan. `,_jsx(_components.code,{children:`plan`}),` and `,_jsx(_components.code,{children:`apply`}),` print a warning for it and skip it, and the owner on the target database stays as it is. When `,_jsx(_components.code,{children:`OWNER TO`}),` shares an `,_jsx(_components.code,{children:`ALTER TABLE`}),` with other actions, only the `,_jsx(_components.code,{children:`OWNER TO`}),` action is skipped.`]})}),`\n`,_jsxs(_components.p,{children:[`Objects created by `,_jsx(_components.code,{children:`apply`}),` are owned by the role that runs it. To get a specific owner, run `,_jsx(_components.code,{children:`apply`}),` as that role, or change the owner outside of `,_jsx(_components.code,{children:`pgschema`}),`:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ALTER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TABLE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` orders `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`OWNER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` app_owner;`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`global-default-privileges`,children:`Global Default Privileges`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`ALTER DEFAULT PRIVILEGES`}),` is supported only with `,_jsx(_components.code,{children:`IN SCHEMA`}),`. See `,_jsx(_components.a,{href:`/syntax/alter_default_privileges`,children:`ALTER DEFAULT PRIVILEGES`}),`.`]}),`\n`,_jsxs(_components.p,{children:[`Without `,_jsx(_components.code,{children:`IN SCHEMA`}),`, the statement sets a default for every schema in the database where the role creates objects. That is database-level state, not part of the schema `,_jsx(_components.code,{children:`pgschema`}),` manages, and several schemas managed separately would each claim it.`]}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[`A global `,_jsx(_components.code,{children:`ALTER DEFAULT PRIVILEGES`}),` statement in your schema files has no effect on the plan. `,_jsx(_components.code,{children:`plan`}),` and `,_jsx(_components.code,{children:`apply`}),` print a warning for it and skip it, and the target database is not changed.`]})}),`\n`,_jsxs(_components.p,{children:[`Apply global default privileges outside of `,_jsx(_components.code,{children:`pgschema`}),`, or scope them to the schema:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`1`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`1`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ALTER`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` DEFAULT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` PRIVILEGES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FOR`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ROLE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` app_owner `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`IN`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SCHEMA`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` public `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GRANT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` TABLES `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`TO`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` app_reader;`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`rename`,children:`Rename`}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.code,{children:`RENAME`}),` is not supported.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Unsupported","description":null,"href":"/syntax/unsupported"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Cluster Level Commands","slug":"cluster-level-commands","depth":2,"children":[]},{"title":"Database Level Commands","slug":"database-level-commands","depth":2,"children":[]},{"title":"Schema Level Commands","slug":"schema-level-commands","depth":2,"children":[]},{"title":"Object Ownership","slug":"object-ownership","depth":2,"children":[]},{"title":"Global Default Privileges","slug":"global-default-privileges","depth":2,"children":[]},{"title":"Rename","slug":"rename","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"pgschema","siteName":"pgschema, Declarative Schema Migration for Postgres","title":"Unsupported - pgschema, Declarative Schema Migration for Postgres","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-09-20T16:54:10.653Z","originalFileLocation":"syntax/unsupported.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"pgschema, Declarative Schema Migration for Postgres\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Unsupported - pgschema, Declarative Schema Migration for Postgres\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"pgschema, Declarative Schema Migration for Postgres\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://www.pgschema.com/syntax/unsupported\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://pgschema.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Unsupported\u0026amp;theme=6773da6c965cf608c2fd9ae4\u0026amp;signature=40ca05789890f5f187f247eff6f3fef3489c63fb551a1fe9e80154a174270ac7\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Unsupported - pgschema, Declarative Schema Migration for Postgres\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://pgschema.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=Unsupported\u0026amp;theme=6773da6c965cf608c2fd9ae4\u0026amp;signature=40ca05789890f5f187f247eff6f3fef3489c63fb551a1fe9e80154a174270ac7\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/pgschema/eVMn3Wop0HZadgSF/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"pgschema, Declarative Schema Migration for Postgres\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#F4473C\">\u003clink data-mint-head rel=\"canonical\" href=\"https://www.pgschema.com/syntax/unsupported\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/syntax/unsupported.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://www.pgschema.com/#organization\",\"name\":\"pgschema, Declarative Schema Migration for Postgres\",\"url\":\"https://www.pgschema.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/pgschema/0WkBUT0FtHZnmbRN/logo/light.png?fit=max\u0026auto=format\u0026n=0WkBUT0FtHZnmbRN\u0026q=85\u0026s=6c255c2bdd005e854bf235c5f89a1384\"}},{\"@type\":\"WebSite\",\"@id\":\"https://www.pgschema.com#website\",\"name\":\"pgschema, Declarative Schema Migration for Postgres\",\"url\":\"https://www.pgschema.com\",\"publisher\":{\"@id\":\"https://www.pgschema.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://www.pgschema.com/syntax/unsupported#webpage\",\"url\":\"https://www.pgschema.com/syntax/unsupported\",\"name\":\"Unsupported\",\"dateModified\":\"2026-09-20T16:54:10.653Z\",\"isPartOf\":{\"@id\":\"https://www.pgschema.com#website\"}},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://www.pgschema.com/syntax/unsupported#article\",\"headline\":\"Unsupported\",\"name\":\"Unsupported\",\"url\":\"https://www.pgschema.com/syntax/unsupported\",\"mainEntityOfPage\":{\"@id\":\"https://www.pgschema.com/syntax/unsupported#webpage\"},\"dateModified\":\"2026-09-20T16:54:10.653Z\",\"publisher\":{\"@id\":\"https://www.pgschema.com/#organization\"},\"isPartOf\":{\"@id\":\"https://www.pgschema.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"pgschema, Declarative Schema Migration for Postgres\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"pgschema, Declarative Schema Migration for Postgres\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/syntax/unsupported.md","siteName":"pgschema, Declarative Schema Migration for Postgres","nav":{"global":null,"tabs":[{"tab":"Docs","pages":[{"title":"Docs","href":""}]},{"tab":"Syntax","pages":[{"title":"Unsupported","href":"/syntax/unsupported"},{"title":"ALTER DEFAULT PRIVILEGES","description":null,"href":"/syntax/alter_default_privileges"},{"title":"COMMENT ON","href":"/syntax/comment_on"},{"title":"CREATE AGGREGATE","href":"/syntax/create_aggregate"},{"title":"CREATE DOMAIN","href":"/syntax/create_domain"},{"title":"CREATE FUNCTION","href":"/syntax/create_function"},{"title":"CREATE INDEX","href":"/syntax/create_index"},{"title":"CREATE MATERIALIZED VIEW","href":"/syntax/create_materialized_view"},{"title":"CREATE POLICY","href":"/syntax/create_policy"},{"title":"CREATE PROCEDURE","href":"/syntax/create_procedure"},{"title":"CREATE SEQUENCE","href":"/syntax/create_sequence"},{"title":"CREATE TABLE","href":"/syntax/create_table"},{"title":"CREATE TRIGGER","href":"/syntax/create_trigger"},{"title":"CREATE TYPE","href":"/syntax/create_type"},{"title":"CREATE VIEW","href":"/syntax/create_view"},{"title":"GRANT / REVOKE","href":"/syntax/grant_revoke"}]},{"tab":"Dev Journal","pages":[{"title":"Dev Journal","href":"/blog/five-lesser-known-postgres-syntax"}]}]},"basePath":"","title":"Unsupported - pgschema, Declarative Schema Migration for Postgres","deploymentId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","buildId":"dpl_vSEmv961Ncyvz1psVwgUnTXQMSYk","dynamics":[],"chunks":[]}