| From: | Serge Fonville <serge(dot)fonville(at)gmail(dot)com> |
|---|---|
| To: | Agustin Larreinegabe <alarreine(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-novice-owner(at)postgresql(dot)org |
| Subject: | Re: PK referenced function |
| Date: | 2013-09-06 13:29:32 |
| Message-ID: | CAOAS_++UyWTLsN3CNZpWdKQrkaaVUFq1+3k+E7WGcdqvL2Ewiw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
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 <alarreine(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2013-09-06 13:51:08 | Re: PK referenced function |
| Previous Message | Agustin Larreinegabe | 2013-09-06 13:26:08 | PK referenced function |