Hi Augustin, PostgreSQL has a couple of possibilities in this regard. For example, http://stackoverflow.com/questions/1152260/postgres-sql-to-list-table-foreign-keyshas 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<https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table> 2013/9/6 Agustin Larreinegabe <alarre...@gmail.com> > 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. >
