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 table1. 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? Henri
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users