Paul Ramsey wrote: > Yes, a temporary table (look up variants of SELECT INTO and INSERT) > should work fine. A view might also work, but I do not know that for > certain. Jeff? Does pgsql2shp look at the geometry_columns table? If is, Nick will have to put a geometry_columns entry in for his temp table/view. dave