Home > mailing lists

Move table - New schema - Mailing list pgsql-general

From	António Rodrigues
Subject	Move table - New schema
Date	September 18, 2012 10:48:48
Msg-id	CABOU0iR=LmA34J=7Zzy2_toGdP+1aDpN0M9gveuB3xWW8SzXkA@mail.gmail.com Whole thread Raw
Responses	Re: Move table - New schema
List	pgsql-general

Hi list,

(newbie question)

I'm trying to move a set of tables between schemas.

Tried:

ALTER TABLE tablename

SET SCHEMA schemaname

It gives me error: "schema schemaname does not exist" (it does)

Any help please.

Thanks,

António

From: Виктор Егоров
Date: 18 September 2012, 10:03:39
Subject: Re: Data recovery after inadvertent update?

From: Rafal Pietrak
Date: 18 September 2012, 11:00:34
Subject: Re: foreign key from array element