[CALUG] Database question

[David Hawkins]

You're looking for an ORM that will auto-discover relationships,  
correct?  I'm nor sure there is one.  Usually you build your schema  
within the ORM's framework.

Are the keys or foreign keys differentiated in some way?  Desc table- 
name | grep key-string may be your best friend here.

- dh

On Feb 25, 2009, at 9:12, Keith <pdragon at pdragon.net> wrote:

> Fairly new to Postgres myself and not really sure I understand what
> you're looking to do. Have you tried looking at PgAdmin to see if it
> can do what you need? Or at least let you better visualize the
> database.
>
> http://www.pgadmin.org/
>
> Keith
>
> On Wed, Feb 25, 2009 at 8:09 AM, Jason C. Miller
> <jason.c.miller at gmail.com> wrote:
>> I love posting weird questions to you guys.  :)
>>
>> So, we have this postgres database that we're using that belongs to  
>> a 3rd
>> party.  It has a metric-ass-ton of tables. NONE of us are  
>> proficient in
>> postgres at all.
>>
>> Given that:
>> 1. we're not that good with PG
>> 2. it's a huge schema that someone else built
>> 3. we haven't undertaken the task to understand the vast # of  
>> relations
>> yet
>> 4. there really are no guidelines regarding what we will be
>> querying...just that it could be anything over time
>>
>> ...we'd like to be able to dynamically query useful information  
>> from it.
>>
>> I had a strange thought last night.  Is there a way that anyone is  
>> aware
>> of to somehow import a postgres database into some kind of
>> object-relational environment that is already aware of table  
>> relations?
>> This would preempt the need for complex sql queries (which I'm not  
>> in the
>> mood to write) and be a much simpler representation of the system.   
>> I'm
>> wondering if perhaps there is a way to export the database's  
>> relational
>> metadata (if it even has any).
>>
>> The first thing that comes to mind would be to use something like
>> ActiveRecord, but that requires intimate relational knowledge and  
>> the need
>> to set up the relations (via models) by hand.  I am looking for the  
>> same
>> end result, though.
>>
>> Any ideas?
>>
>>                                ~j
>>
>> _______________________________________________
>> CALUG mailing list
>> CALUG at unknownlamer.org
>> http://lists.unknownlamer.org/listinfo/calug
>>
>
> _______________________________________________
> CALUG mailing list
> CALUG at unknownlamer.org
> http://lists.unknownlamer.org/listinfo/calug