[postgis-users] (no subject)

[Henri De Feraudy]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100916/d8771b1b/attachment.html>