CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace Synopsis CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | …| PostgreSQL Documentation
F.8. btree_gist — GiST operator classes with B-tree behavior # F.8.1. Example Usage F.8.2. Authors btree_gist provides GiST index operator classes …| PostgreSQL Documentation
Animated by some comments / complaints about Postgres’ missing user variables story on a Reddit post about PostgreSQL pain points in the real world - I thought I’d elaborate a bit on sessions vars - which is indeed a little known Postgres functionality. Although this “alley” has existed for ages...| Kaarel's corner
CREATE FOREIGN TABLE CREATE FOREIGN TABLE — define a new foreign table Synopsis CREATE FOREIGN TABLE [ IF NOT EXISTS …| PostgreSQL Documentation
8.17. Range Types # 8.17.1. Built-in Range and Multirange Types 8.17.2. Examples 8.17.3. Inclusive and Exclusive Bounds 8.17.4. Infinite (Unbounded) Ranges …| PostgreSQL Documentation
CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEW — define a new materialized view Synopsis CREATE MATERIALIZED VIEW [ IF NOT EXISTS …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation