[postgis-users] AddGeometryColumn() Question

[Stephen Woodbridge]

Hi all,

When a create a table using

CREATE TABLE foobar AS SELECT ...
SELECT * INTO TABLE foobar ...

The metadata and constraints that are created by AddGeometryColumn() are 
not created.

What is the correct way to do this?

Can I use AddGeometryColumn() and specify the existing column in the new 
table?

Does it have the smarts to check if it already exists and continue only 
updating the missing information and constraints?

Would it make sense to make it behave like this? exactly for this purpose?

So many questions, so little time!

-Steve