Sample Header Ad - 728x90

How to hide the partition child tables in PostgreSQL?

0 votes
2 answers
1988 views
I am creating partition tables in postgreSQL. And the partition is on date column so its nearly high in number to show in schema. I want to show only my parent table for other users. I tried many searches but this kind of concept is not explained anywhere. This is my hierarchy, Master_table child_01_2013 child_02_2013 .... child_07_2019 so child table is in Monthly partition. I dont want to show all child table in my database. I am using Pg-admin 4 and DB visualizer(Free) tool for my works. Kindly help me to resolve this.
Asked by prabhu (23 rep)
Aug 6, 2019, 11:33 PM
Last activity: Aug 13, 2019, 01:32 PM