Re: PK referenced function

[Serge Fonville <serge.fonville@xxxxxxxxx>]

Hi Augustin,

PostgreSQL has a couple of possibilities in this regard.

For example, http://stackoverflow.com/questions/1152260/postgres-sql-to-list-table-foreign-keys has a couple of very clear queries.

Additionally, it would be very useful if you could further clarify the problem you are trying to solve.

HTH

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!

Please don't get rid of the MCM and MCA programs

2013/9/6 Agustin Larreinegabe <alarreine@xxxxxxxxx>

Hi everyone:

I want to know if exists a postgres function or some easy way to know if a PK in a table is already referenced in another table/tables.

e.g.

I want to delete a row but first I've got to change or delete in the table/tables where is referenced, and I have many table where could be referenced.