Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_foreignkeys
Fields
Name | Data type | Description |
---|---|---|
dvnaam |
text |
|
dvforeignkeyname |
text |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table vwadm_foreignkeys
Definition
CREATE VIEW public.vwadm_foreignkeys (
dvnaam,
dvforeignkeyname)
AS
SELECT upper(pg_constraint.conname::text) AS dvnaam,
lower(pg_constraint.conname::text) AS dvforeignkeyname
FROM pg_constraint
WHERE pg_constraint.contype = 'f'::"char" AND
upper(pg_constraint.conname::text) ~~ 'CFK_%'::text;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
![]() ![]() ![]() |