DB Wiki

User Tools

Site Tools

Trace:
postgresqlpartioning

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
postgresqlpartioning [2022/11/29 10:55] – z0hpvkpostgresqlpartioning [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 43: Line 43:
 From Postgres 11 it is possible to create a default partition. \\ From Postgres 11 it is possible to create a default partition. \\
 <code SQL> <code SQL>
-CREATE TABLE USERS_PART_2021 PARTITION OF USERS_PART DEFAULT;+CREATE TABLE USERS_PART_DF PARTITION OF USERS_PART DEFAULT;
 </code> </code>
  
Line 59: Line 59:
 RETURNING tableoid::regclass, user_id; RETURNING tableoid::regclass, user_id;
 </code> </code>
 +
 +===== Example =====
 +[[PGPartitionExample| Partitioning Example]]\\
 +
  
  
  
postgresqlpartioning.1669719305.txt.gz · Last modified: 2025/03/08 22:23 (external edit)