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
Last activity: Aug 13, 2019, 01:32 PM