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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
