Below is my select statement:
SELECT t.table_catalog AS catalog, t.table_schema AS schema,
t.table_name AS table, u.usename AS owner, c.oid AS table_id FROM
information_schema.tables t, pg_catalog.pg_class c, pg_catalog.pg_user
u WHERE t.table_name = c.relname AND c.relowner = usesysid AND
(t.table_type = 'BASE TABLE' OR t.table_type = 'VIEW' OR t.table_type
= 'LOCAL TEMPORARY') ORDER BY table_name;
and INSERT statement:
query7 = L"INSERT INTO \"abcattbl\" VALUES( 0, $1, (SELECT
c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = c.relnamespace
AND c.relname = $2 AND nc.nspname = $3), \'\', 8, 400, \'N\', \'N\',
0, 1, 0, \'MS Sans Serif\', 8, 400, \'N\', \'N\', 0, 1, 0, \'MS Sans
Serif\', 8, 400, \'N\', \'N\', 0, 1, 0, \'MS Sans Serif\', \'\' ) ON
CONFLICT DO NOTHING;";
Thank you
On Sat, Dec 20, 2025 at 9:47 PM David G. Johnston
<[email protected]> wrote:
>
>
>
> On Thursday, December 18, 2025, Igor Korot <[email protected]> wrote:
>>
>>
>> Using my setup above and assumng my Win locale is en_US.UTF8
>
>
> This seems like an incorrect assumption. The server is expecting UTF8 yet you
> are passing it data that is not valid UTF8 bytes. I infer thus your Windows
> encoding is thus not UTF8.
>
> Suggest you make an even smaller, simpler, and self-contained reproducer and
> include how you are executing the code. You’ve not provided sufficient
> detail for someone else to debug your problem.
>
> David J.
>
