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