{"id":6044,"date":"2024-09-11T12:09:03","date_gmt":"2024-09-11T12:09:03","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=6044"},"modified":"2024-09-11T12:09:05","modified_gmt":"2024-09-11T12:09:05","slug":"the-101s-of-mastering-database-inheritance-in-postgresql","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/","title":{"rendered":"The 101s of Mastering Database Inheritance in PostgreSQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">PostgreSQL is renowned for its powerful features and flexibility, and one of its most intriguing capabilities is support for table inheritance. Table inheritance in PostgreSQL allows you to model hierarchical data structures directly within your database schema. This feature can simplify schema design, reduce redundancy, and enhance query efficiency. In this blog post, we&#8217;ll explore how PostgreSQL implements inheritance, its benefits, and practical examples to help you master this powerful feature.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What is Table Inheritance in PostgreSQL?<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Table inheritance in PostgreSQL allows you to create a hierarchical relationship between tables. This means a table known as a child can inherit columns and constraints from another table known as a parent . This design pattern helps model real-world relationships more naturally and supports object-oriented programming concepts within your relational database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Key Concepts:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Parent Table:<\/strong> The base table from which other tables inherit. It typically contains common attributes and constraints.<\/li>\n\n\n\n<li><strong>Child Table:<\/strong> A table that inherits from a parent table. It can have additional attributes or constraints specific to its type.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">All check constraints and not-null constraints on a parent table are automatically inherited by its children, unless explicitly specified otherwise with\u00a0<code>NO INHERIT<\/code>\u00a0clauses. Other types of constraints (unique, primary key, and foreign key constraints) are not inherited.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using Inheritance in PostgreSQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Here are the steps to create and use inheritance in PostgreSQL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create the Parent table<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Creating the parent table with the common attributes that will be inherited by child tables.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# CREATE TABLE vehicle (\n    id SERIAL PRIMARY KEY,\n    brand VARCHAR(50),\n    model VARCHAR(50),\n    year INT\n);\nCREATE TABLE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Here, we have created the table <code>vehicle<\/code> as the parent table with attributes that are common to all vehicles.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create Child tables<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Creating the child tables that inherit from the parent table. You use the <code>INHERITS<\/code> keyword to specify inheritance.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# CREATE TABLE car (\n    num_doors INT\n) INHERITS (vehicle);\n\nCREATE TABLE bike (\n    has_sidecar BOOLEAN\n) INHERITS (vehicle);\nCREATE TABLE\nCREATE TABLE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Here, <code>car<\/code> and <code>bike<\/code> are child tables that inherit the columns from the <code>vehicle<\/code> table. Each child table also has its own additional attributes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Insert Data into child tables<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Insert data into <code>car<\/code> and <code>bike<\/code> tables<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# INSERT INTO car (brand, model, year, num_doors)\nVALUES ('Toyota', 'Corolla', 2023, 4);\n\nINSERT INTO bike (brand, model, year, has_sidecar)\nVALUES ('Harley-Davidson', 'Sportster', 2024, FALSE);\nINSERT 0 1\nINSERT 0 1<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Check Data in Parent table<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Checking the data in Parent table<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# SELECT * FROM vehicle;\n-&#91; RECORD 1 ]----------\nid    | 1\nbrand | Toyota\nmodel | Corolla\nyear  | 2023\n-&#91; RECORD 2 ]----------\nid    | 2\nbrand | Harley-Davidson\nmodel | Sportster\nyear  | 2024<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Here , we can see the data of both the child tables in the parent table as well.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Add and check the constraints<\/strong> <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We will first add the constraint and check the constraints<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# ALTER TABLE car ADD CONSTRAINT check_num_doors CHECK (num_doors > 0);\nALTER TABLE\npostgres=# SELECT\n    conname AS constraint_name,\n    contype AS constraint_type,\n    condeferrable,\n    condeferred,\n    c.relname AS table_name\nFROM                    \n    pg_constraint AS con\nJOIN                    \n    pg_class AS c ON con.conrelid = c.oid\nWHERE                                    \n    c.relname IN ('vehicle', 'car', 'bike');\n-&#91; RECORD 1 ]---+----------------\nconstraint_name | vehicle_pkey\nconstraint_type | p\ncondeferrable   | f\ncondeferred     | f\ntable_name      | vehicle\n-&#91; RECORD 2 ]---+----------------\nconstraint_name | check_num_doors\nconstraint_type | c\ncondeferrable   | f\ncondeferred     | f\ntable_name      | car\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Use Cases<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>E-commerce Platforms:<\/strong> Inherit attributes of a generic <code>product<\/code> table into specific product types like <code>clothing<\/code>, <code>electronics<\/code>, and <code>furniture<\/code>. This approach streamlines managing different product categories while retaining common attributes.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Content Management Systems:<\/strong> Use inheritance to manage various content types (e.g., <code>article<\/code>, <code>video<\/code>, <code>blog_post<\/code>) that share common attributes like <code>title<\/code>, <code>author<\/code>, and <code>publish_date<\/code>.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Vehicle Tracking Systems:<\/strong> Model different types of vehicles (e.g., <code>car<\/code>, <code>bike<\/code>, <code>truck<\/code>) with shared attributes such as <code>license_plate<\/code>, <code>registration_date<\/code>, and <code>owner<\/code>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL\u2019s table inheritance is a robust feature that enhances schema design by allowing you to model hierarchical relationships and reduce redundancy. By understanding and leveraging inheritance, you can create more organized and flexible database schemas. However, it&#8217;s essential to balance its benefits with potential complexities and performance considerations. With thoughtful design and regular performance monitoring, you can effectively use inheritance to manage and query data in PostgreSQL. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you n Stay tuned&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is renowned for its powerful features and flexibility, and one of its most intriguing capabilities is support for table [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":6056,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1,23,42,89],"tags":[],"class_list":["post-6044","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-others","category-postgresql-14","category-postgresql-15","category-postgresql-16"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The 101s of Mastering Database Inheritance in PostgreSQL - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The 101s of Mastering Database Inheritance in PostgreSQL - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is renowned for its powerful features and flexibility, and one of its most intriguing capabilities is support for table [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-11T12:09:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-11T12:09:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"945\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"The 101s of Mastering Database Inheritance in PostgreSQL\",\"datePublished\":\"2024-09-11T12:09:03+00:00\",\"dateModified\":\"2024-09-11T12:09:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/\"},\"wordCount\":495,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png\",\"articleSection\":[\"Others\",\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/\",\"name\":\"The 101s of Mastering Database Inheritance in PostgreSQL - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png\",\"datePublished\":\"2024-09-11T12:09:03+00:00\",\"dateModified\":\"2024-09-11T12:09:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png\",\"width\":1800,\"height\":945},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The 101s of Mastering Database Inheritance in PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The 101s of Mastering Database Inheritance in PostgreSQL - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"The 101s of Mastering Database Inheritance in PostgreSQL - OpenSource DB","og_description":"PostgreSQL is renowned for its powerful features and flexibility, and one of its most intriguing capabilities is support for table [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2024-09-11T12:09:03+00:00","article_modified_time":"2024-09-11T12:09:05+00:00","og_image":[{"width":1800,"height":945,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png","type":"image\/png"}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"The 101s of Mastering Database Inheritance in PostgreSQL","datePublished":"2024-09-11T12:09:03+00:00","dateModified":"2024-09-11T12:09:05+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/"},"wordCount":495,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png","articleSection":["Others","PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/","url":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/","name":"The 101s of Mastering Database Inheritance in PostgreSQL - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png","datePublished":"2024-09-11T12:09:03+00:00","dateModified":"2024-09-11T12:09:05+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png","width":1800,"height":945},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/the-101s-of-mastering-database-inheritance-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"The 101s of Mastering Database Inheritance in PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",1800,945,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",1800,945,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",1800,945,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6-1024x538.png",1024,538,true],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6-1536x806.png",1536,806,true],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",1800,945,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",1200,630,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",870,457,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",600,315,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/09\/image-6.png",600,315,false]},"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/others\/\" rel=\"category tag\">Others<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"PostgreSQL is renowned for its powerful features and flexibility, and one of its most intriguing capabilities is support for table [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=6044"}],"version-history":[{"count":2,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6044\/revisions"}],"predecessor-version":[{"id":6057,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6044\/revisions\/6057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/6056"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=6044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=6044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=6044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}