-- ALTER TABLE v8users RENAME TO v8users_old;
-- UPDATE Params SET FileName = 'users.usr_old' WHERE FileName = 'users.usr';

-- DROP TABLE v8users;
-- ALTER TABLE v8users_old RENAME TO v8users;
-- UPDATE Params SET FileName = 'users.usr' WHERE FileName = 'users.usr_old';
-- , pg_relation_filepath(table_name) filename

--  create table _error_in_tables ( tname varchar (50),fname varchar (150),errno varchar (10) );

create or replace function check_table_files(scheme varchar)
  RETURNS integer AS
  $BODY$
DECLARE
    table_string record;
    query_string text := '';
    query text := '';
    i integer:=0;
BEGIN

query_string :='SELECT table_name, pg_relation_filepath(table_name) filename FROM information_schema.tables where table_schema='''||scheme||''' ORDE ... Читать дальше »