Thread: Foreign Keys

I would like a graphical interface that would help me manage my foreign
keys. I thought PgAdmin II would do this (it has the Foreign Key object
type) but when I create a foreign key in PG and then try and see it in
PgAdmin II it I don't see anything. I can't create new ones either using the
interface. Am I using the program wrong or is this capability not
implemented yet?

James Friesen

> -----Original Message-----
> From: Friesen, James [mailto:jfriesen@hcjb.org.ec]
> Sent: 29 January 2003 19:13
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Foreign Keys
>
>
> I would like a graphical interface that would help me manage
> my foreign keys. I thought PgAdmin II would do this (it has
> the Foreign Key object
> type) but when I create a foreign key in PG and then try and
> see it in PgAdmin II it I don't see anything. I can't create
> new ones either using the interface. Am I using the program
> wrong or is this capability not implemented yet?

Hi James,

You can create fkeys when you create a table in pgAdmin, or browse
existing keys. You cannot add additional or drop existing keys yet
though, unless you enter the SQL manually. If you do so, you will need
to right-click and Refresh the relevant bit of the treeview to see the
changes.

Regards, Dave.