[GENERAL] copy from .. How to get rid of encoding check for bytea coumns

I am trying to load data into a rather simple table: CREATE TABLE "public"."files" ( "id" SERIAL, "idchar" CHAR(32) NOT NULL, "content" BYTEA, CONSTRAINT "files_pkey" PRIMARY KEY("id") ) WITHOUT OIDS; with this command: copy files (idchar, content) from '/data/1.dat' delimiter '|'; T

[GENERAL] Are stored procedures always kept in memory?

We run several instances of postgre in different countries, and we try keeping them as same as possible, in terms of structure of the tables and function definitions (except the content of schema "config", which differs between dbs). So if we need to implement some different algorithm per countr