 | | From: | jonathan.wallace at gmail.com | | Subject: | Postgresql table management. | | Date: | 9 Jan 2005 20:24:28 -0800 |
|
|
 | Hello,
I've a simple question that I'm having trouble formulating. Please
forgive me if the answer is obvious and/or simple.
I have three tables in a database in postgresql. Two of the tables
have primary keys, id1 and id2, and a name field associated with id1
and id2. id1 and id2 are foreign keys in the third. What do I need to
do to allow editing of the table such that one does not have to
translate between id1 and id1's associated name when editing the third
table?
Thanks in advance,
Jonathan
|
|
| | From: | jonathan.wallace at gmail.com | | Subject: | Re: Postgresql table management. | | Date: | 11 Jan 2005 03:54:35 -0800 |
|
|
| I would guess that my above post is more of an application specific
question than anything else. I now believe that the answer to my
question is, "You need to build a database frontend for an
administrator." Anyone disagree or agree with that?
Jonathan
|
|
| | From: | EricF | | Subject: | Re: Postgresql table management. | | Date: | Wed, 12 Jan 2005 05:26:31 GMT |
|
|
| In article <1105444475.952540.187210@f14g2000cwb.googlegroups.com>, "jonathan.wallace@gmail.com" wrote:
>I would guess that my above post is more of an application specific
>question than anything else. I now believe that the answer to my
>question is, "You need to build a database frontend for an
>administrator." Anyone disagree or agree with that?
> Jonathan
Have you looked at pgAdmin or pgaccess?
Eric
|
|
