[postgis-users] Create View From Spatial Table with libpq
mwtoews at gmail.com
Mon May 24 00:31:26 PDT 2010
2010/5/24 郭家成 <iron1103 at gmail.com>
> So, everything works fine without "CREATE VIEW", weird.
I should have seen that earlier .. views don't have parameters, so that is
why test 1-4 don't work. Views need to have existing columns. What is $1
supposed to be? A geometry column from a different table, or the same table?
If you needs are only temporary, then explore the uses of "select * into *temp
*tt from ..." then use tt like any other table until you don't need it
anymore in the transaction, then it disappears out of sight.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users