Thank you Mike, I've also discover that if you restore a postgis table with the pg_restore, It doesn't automagically recreate the corresponding record in geometry_columns even if the table have contrainst and gist index. (But that's easy to do manually)
Mike Toews wrote: > For PostgreSQL 8.1 and above, this should work: > > ALTER TABLE name SET SCHEMA new_schema; > > http://www.postgresql.org/docs/current/interactive/sql-altertable.html > > -Mike > > Bruno Friedmann wrote: >> I receive some dump (compress -custom) which restore table inside >> public schema. >> >> I need to move them into another schema (postgis table). >> Postgis is installed inside public. >> Is there a quick way to move it without a new dump ? >> (some hundred of gigabit and milions of rows to move) >> >> -- Bruno Friedmann _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
