On Mon, 18 Aug 2025 at 10:32, Andrew Dunstan <and...@dunslane.net> wrote:
> > But the real issue is what to print. In the case of a table, should > > we also show its indexes? What about foreign keys to or from other > > tables? If it's a partitioned table, what about the partitions? > > I'm not sure this is as simple as it seems. > > Agreed it's not simple, but that doesn't mean we should not do it. > Tables are the most obviously complex case. I'm inclined to say foreign > keys to but not from, and also include indexes. But maybe we can provide > several flavors, by allowing some function options, e.g. > Are you sure you don't mean from but not to? If I want foreign keys from a table when looking at that table's definition, they can be part of a single CREATE TABLE statement. If I want foreign keys to that table, I need a bunch of ALTER TABLE statements naming the other tables whose foreign keys point at the table in question.
