Differences

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

--- postgresqlpartioning [2021/12/06 11:30] – external edit 127.0.0.1
+++ postgresqlpartioning [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 38: / Line 38: @@
 -- Inserts will now only work when the created date is in 2021
 </code>
+===== Default =====
+From Postgres 11 it is possible to create a default partition. \\
+<code SQL>
+CREATE TABLE USERS_PART_DF PARTITION OF USERS_PART DEFAULT;
+</code>
+===== Select / Insert =====
+It is possible to show which partitioned table your select or insert query has used. \\
+<code SQL>
+SELECT tableoid, tableoid::regclass, * FROM users_part
+ WHERE user_role = 'A';
+</code>
+<code SQL>
+INSERT INTO users_part (username, user_role)
+VALUES ('bloggs01', 'A')
+RETURNING tableoid::regclass, user_id;
+</code>
+===== Example =====
+[[PGPartitionExample| Partitioning Example]]\\