How Copy 7.3 Schemas? 
Author Message
 How Copy 7.3 Schemas?

This is a multi-part message in MIME format.

------=_NextPart_000_002F_01C2BC69.11D7AB90
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am playing with the new Schema feature in 7.3.  I would like to copy
the public schema into a new schema.  Is there an easy way to do this?
Something I can do with pg_dump (I don=92t see a switch to specify which
schema)  Right now I an only interested in copying the structures =96
later on it would be nice if I could copy the data as well.

=20

Regards

------=_NextPart_000_002F_01C2BC69.11D7AB90
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">

<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {font-family:Arial;

        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>I am playing with the new Schema feature in 7.3.=A0 I wo=
uld
like to copy the public schema into a new schema.=A0 Is there an easy way t=
o do
this?=A0 Something I can do with pg_dump (I don&#8217;t see a switch to spe=
cify
which schema)=A0 Right now I an only interested in copying the structures &=
#8211;
later on it would be nice if I could copy the data as well.</span></font></=
p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span style=3D'font-size:1=
0.0pt;
font-family:Arial'>Regards</span></font></p>

</div>

</body>

</html>

------=_NextPart_000_002F_01C2BC69.11D7AB90--



Sun, 03 Jul 2005 20:40:02 GMT
 How Copy 7.3 Schemas?

A drity method could be.
create table schema2.table2 as select * from schema1.table1 ;
in a loop that uses system catalogs.

regds
mallah.


Quote:
> I am playing with the new Schema feature in 7.3.  I would like to copy
> the public schema into a new schema.  Is there an easy way to do this?
> Something I can do with pg_dump (I don=92t see a switch to specify which
> schema)  Right now I an only interested in copying the structures =96
> later on it would be nice if I could copy the data as well.

> Regards

--=20
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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Mon, 04 Jul 2005 15:04:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Segmentation fault while COPY in 7.3

2. COPY..FROM question on 7.3

3. Copy, Cut and Paste in 7.3 (non-graphical) editor

4. Reducing Redo Copy latch contention in 7.3 NT server

5. COPY..FROM question on 7.3

6. COPY command in oracle 7.3 problem????

7. Relocating/Copying Tablespaces in Oracle 7.3/NT

8. Copying schemas ?

9. How to copy schemas across difference databases

10. Copying records between schemas

11. XML Schemas and mapping schemas

12. Personal oracle 7.3 to Personal oracle 7.3 ( SQL*NET)


 
Powered by phpBB® Forum Software