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)
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
