[postgis-users] real noob question about moving a table from public to another schema

[Mike Toews]

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)
>
>