igilfanov

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:tns="urn://x-artefacts-smev-gov-ru/supplementary/commons/1.2"
           targetNamespace="urn://x-artefacts-smev-gov-ru/supplementary/commons/1.2" elementFormDefault="qualified"
           attributeFormDefault="unqualified" version="1.2">
    <xs:group name="PhysicalPersonQualifiedName-ModelGroup">
        <xs:annotation>
            <xs:documentation>ФИО физического лица.</xs:documentation>
        </xs:annotation>
        <xs:sequence>

igilfanov

CREATE OR REPLACE FUNCTION trigger_fooview_before_insert()
  RETURNS trigger AS $$
  DECLARE _q varchar; 

  BEGIN

   _q := (SELECT execute(('CREATE TABLE IF NOT EXISTS sch.foo (i integer')::text) WHERE NOT EXISTS(SELECT * FROM information_schema.tables WHERE table_schema = 'sch' AND table_name = 'foo')) ;

   EXECUTE 'INSERT INTO sch.foo VALUES('|| NEW.i::text ||')';