Re: libpq, PQExecParams and the inserting of binary data

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Re: libpq, PQExecParams and the inserting of binary data
Дата
Msg-id 20050603211559.5392884@localhost
обсуждение исходный текст
Ответ на Re: libpq, PQExecParams and the inserting of binary data  (David Hinkle <drachs@gmail.com>)
Список pgsql-interfaces
    David Hinkle wrote:

> I will try this.  Out of curiosity, where does the value of 17 for the
> OID field come from?

From the pg_type table:

template1=# select oid from pg_type where typname='bytea';oid 
----- 17
(1 row)

Alternatively, there's the server/catalog/pg_type.h include file
which has #defines for built-in datatypes:

$ grep BYTEA server/catalog/pg_type.h
#define BYTEAOID                17

-- DanielPostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq, PQExecParams and the inserting of binary data
Следующее
От: "Daniel Verite"
Дата:
Сообщение: Re: libpq, PQExecParams and the inserting of binary data