Re: [GENERAL] Queries for Diagramming Schema Keys

On Mon, Aug 14, 2017 at 6:38 PM, wrote: > ... > > Just to add that running psql with the -E switch is REALLY handy for > seeing how psql executes queries to > > find how tables etc are put together. > > I can't actually use that feature to gather the information I'm

Re: [GENERAL] Queries for Diagramming Schema Keys

... > Just to add that running psql with the -E switch is REALLY handy for seeing > how psql executes queries to > find how tables etc are put together. I can't actually use that feature to gather the information I'm interested in since all I have are tables and data with no formal

Re: [GENERAL] Queries for Diagramming Schema Keys

...snip... For all tables and columns I get no output at all. Basically I need all tables and columns for which the column is neither a regular primary key, nor a foreign key. This will be marked as an attribute in the diagramming program. Your query for primary keys which are not foreign keys

Re: [GENERAL] Queries for Diagramming Schema Keys

Just to add that running psql with the -E switch is REALLY handy for seeing how psql executes queries to find how tables etc are put together.

Re: [GENERAL] Queries for Diagramming Schema Keys

On Mon, Aug 14, 2017 at 2:46 PM, wrote: > Hi, > > I'm trying to write an application (using libpqxx/C++) which creates > graphical images of large and complex relations between tables (basically > an SVG image with hot spots for drilling down on details). I need to >

[GENERAL] Queries for Diagramming Schema Keys

Hi, I'm trying to write an application (using libpqxx/C++) which creates graphical images of large and complex relations between tables (basically an SVG image with hot spots for drilling down on details). I need to essentially create icons of tables and their columns, and then draw