[postgis-users] Create View From Spatial Table with libpq

[Mike Toews]

2010/5/23 郭家成 <iron1103 at gmail.com>

> Hi Mike,
> Thanks for your reply, but it still doesn't work.
> The key point possibly lies in *Oid paramtypes[1]={0}*,
> Where can I find the ParamType of Geometry or Bytea?
>

They are defined in the system tables:

select oid, * from pg_type where typname='geometry' or typname='bytea';

I'm not sure if the oid for geometry is constant with different
installations (mine is 16892). Bytea is always 17, since it is hard-coded
in src/include/catalog/pg_type.h

-Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100523/9a01eb22/attachment.html>