On Fri, Nov 4, 2011 at 1:57 PM, <thatsanicehatyouhave@xxxxxxx> wrote:
Hi,
I have a database where I wasn't explicitly using schemas when I started it (i.e. everything was simply under "public"). I've since created several schemas and renamed the "public" schema to something else. When I look at the definitions (in PGAdmin III), the CREATE statement for the old tables look like this:
CREATE TABLE foo ( ...
whereas for my newer tables the full schema path is there:
CREATE TABLE myschema.bar ( ...
Is there a way that the explicit schema can be added to my older tables? The reason I want to do this is that I'm having a problem with external code (SQLAlchemy) when trying to get foreign key information through reflection-- the table doesn't seem to be found.
Does this even make sense since the tables are definitely in the new schema anyway?
Cheers,
Demitri
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
You can use ALTER TABLE (http://www.postgresql.org/docs/current/static/sql-altertable.html) to set the schema of existing tables:
ALTER TABLE foo SET SCHEMA bar
-Adam
