PGSQL INTERFACES PGADMIN HACKERS 18 RE WINDOWS PGADMIN III SUGGESTION
From: dpage@no-spam ("Dave Page")
Subject: Re: windows pgAdmin III suggestion
Date: Sun, 12 Dec 2004 10:09:26 -0000


=20

________________________________

From: pgadmin-hackers-owner@no-spam [mailto:pgadmin-hackers-owner@no-spam On Behalf Of Darren Westmore Sent: 09 December 2004 12:02
To: pgadmin-hackers@no-spam Subject: [pgadmin-hackers] windows pgAdmin III suggestion =09
=09

Hi,

=20

I have been using Postgresql v8 and pgAdmin III on the win32
platform for a month or so now and it looks really good.

One frustration on the windows platform is that there isn't a built in metadata export utility. It would be great to add it in as many developers build schemas on windows and then upload to larger machines for application testing. At the moment I am trying to use the EMS tools to do this, but it is turning into a frustrating experience.

=20

Do you have any plans to add in this type of utility to the windows version?

=20

Hi Darren,

=20

In 1.2.0 you can use the backup tool to export a schema-only backup of a database. If I understand your problem correctly this should do what you need.

=20

Regards, Dave.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<STYLE>@no-spam {
font-family: Book Antiqua;
}
@no-spam Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline }
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline }
A:visited {
COLOR: #606420; TEXT-DECORATION: underline }
SPAN.MsoHyperlinkFollowed {
COLOR: #606420; TEXT-DECORATION: underline }
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: windowtext; FONT-STYLE: normal; =
FONT-FAMILY: "Book Antiqua"; TEXT-DECORATION: none }
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-GB vLink=3D#606420 link=3Dblue>
<DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff=20
size=3D2></FONT> </DIV><BR>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
pgadmin-hackers-owner@no-spam [mailto:pgadmin-hackers-owner@no-spam <B>On Behalf Of =
</B>Darren=20
Westmore<BR><B>Sent:</B> 09 December 2004 12:02<BR><B>To:</B>=20
pgadmin-hackers@no-spam<BR><B>Subject:</B> [pgadmin-hackers] =
windows=20
pgAdmin III suggestion<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book =
Antiqua'">Hi,</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book =
Antiqua'"></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book Antiqua'">I have been =
using=20
Postgresql v8 and pgAdmin III on the win32 platform for a month or so =
now and=20
it looks really good.</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book Antiqua'">One frustration =
on the=20
windows platform is that there isn’t a built in metadata export =
utility. It=20
would be great to add it in as many developers build schemas on =
windows and=20
then upload to larger machines for application testing. At the moment =
I am=20
trying to use the EMS tools to do this, but it is turning into a =
frustrating=20
experience.</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book =
Antiqua'"></SPAN></FONT> </P>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book Antiqua'">Do you have any =
plans to=20
add in this type of utility to the windows version?</SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Book Antiqua" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Book =
Antiqua'"></SPAN></FONT><FONT=20
face=3D"Book Antiqua" size=3D2></FONT> </P></DIV></BLOCKQUOTE>
<P class=3DMsoNormal dir=3Dltr><SPAN class=3D993500710-12122004><FONT=20
face=3D"Book Antiqua" size=3D2>Hi Darren,</FONT></SPAN></P>
<P class=3DMsoNormal dir=3Dltr><SPAN class=3D993500710-12122004><FONT=20
face=3D"Book Antiqua" size=3D2></FONT></SPAN> </P>
<P class=3DMsoNormal dir=3Dltr><SPAN class=3D993500710-12122004><FONT=20
face=3D"Book Antiqua" size=3D2>In 1.2.0 you can use the backup tool to =
export a=20
schema-only backup of a database. If I understand your problem correctly =
this=20
should do what you need.</FONT></SPAN></P>
<P class=3DMsoNormal dir=3Dltr><SPAN class=3D993500710-12122004><FONT=20
face=3D"Book Antiqua" size=3D2></FONT></SPAN> </P>
<P class=3DMsoNormal dir=3Dltr><SPAN class=3D993500710-12122004><FONT=20
face=3D"Book Antiqua" size=3D2>Regards, =
Dave.</FONT></SPAN></P></BODY></HTML>