Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: RDBMS 'Pretty' Schema

by graff (Chancellor)
on Jan 07, 2003 at 03:40 UTC ( [id://224839]=note: print w/replies, xml ) Need Help??


in reply to RDBMS 'Pretty' Schema

Cool graphic, but I couldn't quite guess what all the symbolism was supposed to mean... (I'm sure it's easy, once you learn it.)

Does PostgreSQL work like Oracle, storing the table names, column names, data types, constraints (like "primary key", "unique", "not-null", etc), and "foreign key" (join-column) relations in it's own set of distinctly named tables? If so, then doing a suitable set of queries on these tables will give you the data you need to create such a chart, and if you're already using DBI and DBD::Postgres, it should be pretty quick work to cook it up.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://224839]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (4)
As of 2024-04-20 09:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found