Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: RDBMS 'Pretty' Schema

by graff (Chancellor)
on Jan 07, 2003 at 03:40 UTC ( #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
Node Status?
node history
Node Type: note [id://224839]
help
Chatterbox?
[Corion]: Discipulus: Yeah, from my investigations, you can somewhat silence+disable Cortana, but some services of it remain always running unfortunately. What a waste of resources :-/
[Corion]: I hope you had a good weekend still ;)
choroba had a workshop with the band
[choroba]: which counts as a good weekend
[Discipulus]: yes, (at least until Sun afternoon...): Saturday we got splendid birthday party in a park: lot of eat, drink and children amusement: bag running, magnetic fishing, rope and that big pot full of candies to smash with a club

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2017-09-25 08:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (277 votes). Check out past polls.

    Notices?