CREATE OR REPLACE FUNCTION permission_table_update()
  RETURNS trigger AS
$BODY$
BEGIN
	--EXECUTE 'ALTER TABLE permissions ADD COLUMN "g3" text'; // Этот вариант работает также, т.е. никак
	EXECUTE 'ALTER TABLE permissions ADD COLUMN  '|| quote_ident(NEW.fio::text) ||' boolean default false';
	RETURN NEW;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION permission_table_update()
  OWNER TO postgres;

select * from information_schema.columns where table_name = 'permissions';

insert into employees (fio,userid) values ('АБВ','777');

ОШИБКА:  колонка "АБВ" отношения "permissions" уже существует
КОНТЕКСТ:  SQL-оператор: "ALTER TABLE biotime.public.permissions ADD COLUMN  "АБВ" boolean default false"
функция PL/pgSQL permission_table_update(), строка 4, оператор оператор EXECUTE
********** Ошибка **********

ОШИБКА: колонка "АБВ" отношения "permissions" уже существует
SQL-состояние: 42701
Контекст: SQL-оператор: "ALTER TABLE biotime.public.permissions ADD COLUMN  "АБВ" boolean default false"
функция PL/pgSQL permission_table_update(), строка 4, оператор оператор EXECUTE

"tableoid";"oid";4;-7;f
"cmax";"cid";4;-6;f
"xmax";"xid";4;-5;f
"cmin";"cid";4;-4;f
"xmin";"xid";4;-3;f
"ctid";"tid";6;-1;f
"fio";"varchar";-1;1;f

CREATE TRIGGER permission_table_update
BEFORE INSERT [color=purple]OR UPDATE OR DELETE ON employees[/color]
FOR EACH ROW EXECUTE PROCEDURE permission_table_update();

CREATE TRIGGER permission_table_update
BEFORE INSERT ON employees 
FOR EACH ROW EXECUTE PROCEDURE permission_table_update();

-- Database: test
CREATE DATABASE test
  WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'ru_RU.UTF-8'
       LC_CTYPE = 'ru_RU.UTF-8'
       CONNECTION LIMIT = -1;
GRANT ALL ON DATABASE test TO postgres;

-- Table: employees
CREATE TABLE employees
(
  userid character varying NOT NULL,
  fio character varying NOT NULL,
  CONSTRAINT empl_pki PRIMARY KEY (userid)
);

-- Rule: emp_update ON employees
CREATE OR REPLACE RULE emp_update AS
    ON INSERT TO employees
   WHERE (EXISTS ( SELECT 1
           FROM employees employees_1
          WHERE employees_1.userid::text = new.userid::text)) DO INSTEAD  UPDATE employees SET fio = new.fio
  WHERE employees.userid::text = new.userid::text;

-- Function: permission_table_update()
CREATE OR REPLACE FUNCTION permission_table_update()
  RETURNS trigger AS
$BODY$
BEGIN
	EXECUTE 'ALTER TABLE permissions ADD COLUMN  ' || quote_ident(NEW.fio::text) || ' boolean default false';
	RETURN NEW;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION permission_table_update()
  OWNER TO postgres;
  
-- Trigger: permission_table_update on employees
CREATE TRIGGER permission_table_update
  BEFORE INSERT OR UPDATE OR DELETE
  ON employees
  FOR EACH ROW
  EXECUTE PROCEDURE permission_table_update();

-- Table: permissions
CREATE TABLE permissions
(
  fio character varying
);

-- Вставляем данные
INSERT INTO employees (userid, fio) VALUES ('778', 'AAC');

WHERE (EXISTS ( SELECT 1
           FROM employees employees_1
          WHERE employees_1.userid::text = new.userid::text))

WHERE (EXISTS ( SELECT 1
           FROM employees employees_1
          WHERE employees_1.userid::text = new.userid::text))