Differences

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

--- postgresqlpartioning [2022/11/29 10:51] – z0hpvk
+++ postgresqlpartioning [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. \\
 <code SQL>
-CREATE TABLE USERS_PART_2021 PARTITION OF USERS_PART DEFAULT;
+CREATE TABLE USERS_PART_DF PARTITION OF USERS_PART DEFAULT;
 </code>
-===== Select =====
+===== Select / Insert =====
-It is possible to show which partitioned table your select query has used. \\
+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]]\\