select name,setting from pg_settings where name like '%encod%' or name like '%lc%' order by 2;

create extension if not exists xml2;
drop table if exists tmp_xml;
create temporary table tmp_xml(id serial, xml text);
insert into tmp_xml (xml) select '<?xml version="1.0" encoding="windows-1251"?>
<library>
  <format dep="Департамент-depart" name="Имя-name">
  </format>
</library>
';

select t.*
from xpath_table('id', 'xml', 'tmp_xml', '/library/format/@dep|/library/format/@name', 'true')
as t (id integer, dep varchar(50), name varchar(50));

create extension if not exists xml2;
drop table if exists tmp_xml;
create temporary table tmp_xml(id serial, xml text);
insert into tmp_xml (xml) select '<?xml version="1.0" encoding="utf8"?>
<library>
  <format dep="Департамент-depart" name="Имя-name">
  </format>
</library>
';

select t.*
from xpath_table('id', 'xml', 'tmp_xml', '/library/format/@dep|/library/format/@name', 'true')
as t (id integer, dep varchar(50), name varchar(50));