Загрузка данных


create or replace function f_log_ddl()
returns event_trigger as $$
begin
insert into ddl_log(user_name, date_time, obj_name, ddl_command)
values (current_user, current_timestamp, tg_tag, current_query());
create event trigger tr_log_ddl
on ddl_command_end
execute function f_log_ddl();