"Dean Gibson (DB Administrator)" <dba-sql(at)ultimeth(dot)net> writes:
> I'm using PostgreSQL 7.3.2 (from RPM on this site) on RH Linux 7. I'm investigating using "schemas", but after I create a schema, I try to rename an existing table into the new schema with:
> ALTER TABLE name RENAME TO schema.name;
There's no provision for moving things across schemas at the moment.
regards, tom lane