pggeodb-preprod.nancy.inra.fr/db_onf_gde - db_onf_gde on pggeodb-preprod.nancy.inra.fr
Previous topic Chapter index Next topic

Function: _overview_constraint_info

 

 

Schema

public

 

Owner

postgres

 

Descriptions

There is no description for function _overview_constraint_info

 

Options

Option

Value

Returns

record

Language

sql

Parameters

ovschema name

ovtable name

ovcolumn name

out refschema name

out reftable name

out refcolumn name

out factor integer

 

Definition

CREATE OR REPLACE FUNCTION public._overview_constraint_info (
 ovschema name,
 ovtable name,
 ovcolumn name,
 out refschema name,
 out reftable name,
 out refcolumn name,
 out factor integer
)
RETURNS record AS
$span$
SELECT

split_part(split_part(s.consrc, '''::name', 1), '''', 2)::name,
split_part(split_part(s.consrc, '''::name', 2), '''', 2)::name,
split_part(split_part(s.consrc, '''::name', 3), '''', 2)::name,
trim(both from split_part(s.consrc, ',', 2))::integer
FROM pg_class c, pg_namespace n, pg_attribute a, pg_constraint s
WHERE n.nspname = $1
AND c.relname = $2
AND a.attname = $3
AND a.attrelid = c.oid
AND s.connamespace = n.oid
AND s.conrelid = c.oid
AND a.attnum = ANY (s.conkey)
AND s.consrc LIKE '%_overview_constraint(%'
$span$
LANGUAGE
'sql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic