{"result":{"depiction_url":null,"edges":{},"id":2671,"is_a":["categorization","keyword","keyword_technology"],"links":[{"rel":"self","target":"https:\/\/zotonic.com\/.zotonic\/websub\/topic\/2671"},{"rel":"hub","target":"https:\/\/zotonic.com\/.zotonic\/websub"}],"medium":null,"medium_url":null,"name":"zotonic_topic_postgresql","page_url":{"en":"https:\/\/zotonic.com\/page\/2671\/postgresql","x-default":"https:\/\/zotonic.com\/page\/2671\/postgresql"},"preview_url":null,"resource":{"subject_topic_source_url":"https:\/\/www.wikidata.org\/wiki\/Q192490","version":1,"pivot_location_lat":null,"title":"PostgreSQL","is_authoritative":true,"body":"<h2>For programmers<\/h2><p>Covers schemas queries transactions indexes constraints and migrations.<\/p><h2>For content editors<\/h2><p>Stores content users settings relations forms and operational records.<\/p>","slug":"postgresql","subject_topic_evidence":"z_db and Zotonic site schemas","is_protected":true,"visible_for":0,"tz":"Europe\/Amsterdam","subject_topic_aliases":["Postgres","SQL"],"language":["en"],"is_featured":false,"content_group_id":{"id":339,"is_a":["meta","content_group"],"name":"default_content_group","title":{"_type":"trans","tr":{"en":"Default Content Group"}},"uri":"https:\/\/zotonic.com\/id\/default_content_group"},"category_id":{"id":2547,"is_a":["meta","category"],"name":"keyword_technology","title":"Technology","uri":"https:\/\/zotonic.com\/id\/keyword_technology"},"publication_start":"2026-09-09T13:41:26Z","subject_topic_wikidata_label":"PostgreSQL","pivot_location_lng":null,"name":"zotonic_topic_postgresql","is_unfindable":false,"is_published":true,"summary":"The relational database management system used for persistent Zotonic site data.","subject_topic_facet":"technology","pivot_geocode":null,"subject_topic_content_editor_context":"Stores content users settings relations forms and operational records.","subject_topic_slug":"postgresql","created":"2026-09-09T13:41:26Z","uri":null,"is_dependent":false,"publication_end":"9999-06-01T00:00:00Z","modifier_id":{"id":1,"is_a":["person"],"name":"administrator","title":"Site Administrator","uri":"https:\/\/zotonic.com\/id\/1"},"subject_topic_wikidata_id":null,"privacy":0,"subject_topic_hash":"15c03def0eb9342aee02fcc6f193a8fb5319dee9b6fdf13287e845e12906ac95","creator_id":{"id":1,"is_a":["person"],"name":"administrator","title":"Site Administrator","uri":"https:\/\/zotonic.com\/id\/1"},"modified":"2026-09-09T13:41:26Z","title_slug":"postgresql","subject_topic_priority":"core","subject_topic_programmer_context":"Covers schemas queries transactions indexes constraints and migrations."},"uri":"https:\/\/zotonic.com\/id\/2671","uri_template":"https:\/\/zotonic.com\/id\/:id","websub":{"hub":"https:\/\/zotonic.com\/.zotonic\/websub","topic":"https:\/\/zotonic.com\/.zotonic\/websub\/topic\/2671"}},"status":"ok"}