Hi,<br /><br />I've got 2 views - each with identical column names. I want to create an aggregate view of both tables
asa new view. But when I try to do this I understandably get errors on duplicate fields.<br /><br />As an example: <br
/><br/>CREATE VIEW gnis_view AS SELECT * FROM gnis_international_view, gnis_usa_view;<br />ERROR: column "the_geom"
duplicated<br/>ERROR: column "the_geom" duplicated<br /><br />Any ideas on how I can achieve what I am seeking? <br
/>Cheers,<br/>dylan<br />