Igor Korot wrote:
> In my case I simply executing:
>
> 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;
>
> So I presume the result set will be in a text format, right? For all
> columns?
Yes. Aside from fetching from a binary cursor, I don't think there
is any other way to get binary results from a PQexec() call.
In particular, bytea columns come back encoded as text
according to the bytea_output setting.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite