Обсуждение: designer tool connect to PostgreSQL
<br /><font face="Times New Roman" size="2">Hi,</font><br /><br /><font face="Times New Roman" size="2">i use postgresqlas my database. does anyone know the designer tool that can connect to postgeSQL ??? meaning to say the tools </font><br/><font face="Times New Roman" size="2">can handle design task like create table , etc . appreciate if u can givethe specific URL. thanks in advance. </font>
Well, there's phpPgAdmin. It's available at http://phppgadmin.sourceforge.net/ Yasir On Mon, 8 Mar 2004 azwa@nc.com.my wrote: > Date: Mon, 8 Mar 2004 10:13:53 +0800 > From: azwa@nc.com.my > To: pgsql-sql@postgresql.org > Subject: [SQL] designer tool connect to PostgreSQL > > Hi, > > i use postgresql as my database. does anyone know the designer tool that > can connect to postgeSQL ??? meaning to say the tools > can handle design task like create table , etc . appreciate if u can give > the specific URL. thanks in advance.
azwa@nc.com.my schrieb: > > Hi, > > i use postgresql as my database. does anyone know the designer tool that > can connect to postgeSQL ??? meaning to say the tools > can handle design task like create table , etc . appreciate if u can > give the specific URL. thanks in advance. Try this one: http://www.aquafold.com/ Here you can connect not only to Postgres, but also to MySQL, Oracle, ... And you can handle several databases, even on remote systems. It's really good designed. Silke
Hi, I was wondering if it is possible to query the sytem tables to get an overview of user logins in psql. I've searched the documentation but I can't find a system table that stores login information, but I might have overlooked something... With regards, Daniel Doorduin
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Daniel Doorduin wrote: | Hi, | | I was wondering if it is possible to query the sytem tables to get | an overview of user logins in psql. Check out the pg_user table. Regards, - -- Radu-Adrian Popescu CSA, DBA, Developer Aldratech Ltd. +40213212243 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFATGvDVZmwYru5w6ERAlJ7AJ9RLaEkboJ+YNuwEcmur/OXnhlB2ACgoXum GEy4Lun4Gtmi3FJkWFby5T8= =4JRJ -----END PGP SIGNATURE-----
<br /> Rekall ... <br /> <a class="moz-txt-link-freetext" href="http://www.totalrekall.co.uk/">http://www.totalrekall.co.uk/</a> (commercial website)<br /> <a class="moz-txt-link-freetext"href="http://www.rekallrevealed.org/">http://www.rekallrevealed.org/</a> (free sources)<br/><br /> for designing different RDBMS like mysql, postgresl, oracle and other ...<br /> free with sources ...<br /> but packages for windows or linux are not free.<br /><br /> Ben<br /><br /> Yasir Malik a écrit : <blockquote cite="midPine.NEB.4.58.0403072252450.28927@dab.cs.stevens-tech.edu"type="cite"><pre wrap="">Well, there's phpPgAdmin. It'savailable at <a class="moz-txt-link-freetext" href="http://phppgadmin.sourceforge.net/">http://phppgadmin.sourceforge.net/</a> Yasir On Mon, 8 Mar 2004 <a class="moz-txt-link-abbreviated" href="mailto:azwa@nc.com.my">azwa@nc.com.my</a> wrote: </pre><blockquote type="cite"><pre wrap="">Date: Mon, 8 Mar 2004 10:13:53 +0800 From: <a class="moz-txt-link-abbreviated" href="mailto:azwa@nc.com.my">azwa@nc.com.my</a> To: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a> Subject: [SQL] designer tool connect to PostgreSQL Hi, i use postgresql as my database. does anyone know the designer tool that can connect to postgeSQL ??? meaning to say the tools can handle design task like create table , etc . appreciate if u can give the specific URL. thanks in advance. </pre></blockquote><pre wrap=""> ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend </pre></blockquote>
take a look at http://techdocs.postgresql.org/guides/GUITools Robert Treat On Tue, 2004-03-09 at 02:53, BenLaKnet wrote: > > Rekall ... > http://www.totalrekall.co.uk/ <http://www.totalrekall.co.uk/> > (commercial website) > http://www.rekallrevealed.org/ <http://www.rekallrevealed.org/> > (free sources) > > for designing different RDBMS like mysql, postgresl, oracle and other > ... > free with sources ... > but packages for windows or linux are not free. > > Ben > > Yasir Malik a écrit : > > Well, there's phpPgAdmin. It's available at > > http://phppgadmin.sourceforge.net/ <http://phppgadmin.sourceforge.net/> > > > > Yasir > > > > On Mon, 8 Mar 2004 azwa@nc.com.my <mailto:azwa@nc.com.my> wrote: > > > > > > Date: Mon, 8 Mar 2004 10:13:53 +0800 > > From: azwa@nc.com.my <mailto:azwa@nc.com.my> > > To: pgsql-sql@postgresql.org <mailto:pgsql-sql@postgresql.org> > > Subject: [SQL] designer tool connect to PostgreSQL > > > > Hi, > > > > i use postgresql as my database. does anyone know the designer tool that > > can connect to postgeSQL ??? meaning to say the tools > > can handle design task like create table , etc . appreciate if u can > give > > the specific URL. thanks in advance. > -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
<font face="Times New Roman" size="2">Hi,</font><br /><br /><font face="Times New Roman" size="2"> thanks to all for theresponnd...i've look into all the tools mentioned and found many tools which has a great feautre such as designing/modelling</font><br/><font face="Times New Roman" size="2">the object/table but it seems look like that there isno tools that can do the ETL process. thanks in advance</font><br /><br /><br /><table width="100%"><tr valign="top"><td></td><td><divalign="center"><font face="sans-serif" size="2"><b>Rich Hall <rhall@micropat.com></b></font></div><divalign="center"><p><font face="sans-serif" size="2">03/08/2004 10:55 AM EST</font></div><divalign="center"><br /></div></td><td><font face="sans-serif" size="2"> To: azwa@nc.com.my</font><br/><font face="sans-serif" size="2"> cc: </font><br /><font face="sans-serif" size="2"> Subject: Re: [SQL] designer tool connect to PostgreSQL</font></td></tr></table><br /><br /><font face="CourierNew" size="2"><br /> EMS has PGManager, a great tool.<br /><br /> Rick<br /><br /> azwa@nc.com.my wrote:<br/><br /> ><br /> > Hi,<br /> ><br /> > i use postgresql as my database. does anyone know the designertool <br /> > that can connect to postgeSQL ??? meaning to say the tools<br /> > can handle design task likecreate table , etc . appreciate if u can <br /> > give the specific URL. thanks in advance. <br /><br /><br /> --<br /> _____________________________________________________________<br /> Richard Hall<br /> Developer<br /> MicroPatentLLC<br /> 250 Dodge Avenue<br /> East Haven, Connecticut 06512<br /> Tel: 203.868.3321<br /> Fax: 203.466.5054<br/> Eml: rhall@micropat.com<br /> Web: www.micropat.com<br /><br /> MicroPatent is an Information HoldingsInc. company (NYSE:IHI).<br /><br /></font><br />
On Thu, 11 Mar 2004 azwa@nc.com.my wrote: > Hi, > > thanks to all for the responnd...i've look into all the tools mentioned > and found many tools which has a great feautre such as designing/modelling > the object/table but it seems look like that there is no tools that can do > the ETL process. thanks in advance from a google search for postgresql and etl: http://www.safe.com/news/2003/sept16_2003.htm http://cloveretl.berlios.de/ There may be others, I'm not sure.