Moving tables accross schemas in PostgreSQL 7.3

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Moving tables accross schemas in PostgreSQL 7.3
Date: 2002-11-30 19:12:01
Message-ID: 200212010042.01865.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi folks,

what would be the best way of moving my tables out of public
schema to a schema "foo"?

I have few a 100s of tables to move?

Regds
Mallah.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

Browse pgsql-sql by date

  From Date Subject
Next Message Evgen Potemkin 2002-12-01 18:49:54 SQL99 <search or cycle clause>
Previous Message Rajesh Kumar Mallah. 2002-11-30 19:06:32 How to take advantage of PREPARED QUERIES of PGSQL 7.3 in mod_perl enviornment?