Thread: designer tool connect to PostgreSQL

designer tool connect to PostgreSQL

From
azwa@nc.com.my
Date:
<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> 

Re: designer tool connect to PostgreSQL

From
Yasir Malik
Date:
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.


Re: designer tool connect to PostgreSQL

From
Silke Trissl
Date:
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



Login information in system tables

From
"Daniel Doorduin"
Date:
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



Re: Login information in system tables

From
Radu-Adrian Popescu
Date:
-----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-----




Re: designer tool connect to PostgreSQL

From
BenLaKnet
Date:
<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>

Re: designer tool connect to PostgreSQL

From
Robert Treat
Date:
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



Re: designer tool connect to PostgreSQL

From
azwa@nc.com.my
Date:
<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 /> 

Re: designer tool connect to PostgreSQL

From
"scott.marlowe"
Date:
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.