[postgis-users] (no subject)
Henri De Feraudy
feraudyh at yahoo.com
Thu Sep 16 08:11:54 PDT 2010
The SQL Cookbook recommends the following SQL code to copy a table's structure
from table1 to table2:
create table table2 as select * from table1 where 1=0;
What's great about this is that it obviates the need to know the structure of
But what if table1 has a geometry column?
As geometry column existence is recorded in some other tables it doesnt look as
if the above trick is doing enough.
What's your suggestion?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users