Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-29 Thread Wolfgang Keller
> Can anyone tell me which free GUI based tools are available for > creating database diagrams for my database in postgresql. One standard answer to this frequently asked question is: http://www.databaseanswers.org/modelling_tools.htm Sincerely, Wolfgang -- Sent via pgsql-general mailing lis

Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread David Goodenough
On Friday 28 Dec 2012, nevillekb wrote: > Hi, > > Can anyone tell me which free GUI based tools are available for creating > database diagrams for my database in postgresql. > > Thanks, > > Neville. > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Tool-to-c

Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread Ognjen Blagojevic
Neville, On 28.12.2012 7:52, nevillekb wrote: Can anyone tell me which free GUI based tools are available for creating database diagrams for my database in postgresql. This was asked many times before, search the archives. E.g: http://archives.postgresql.org/pgsql-general/2011-08/msg01023.php

[GENERAL] Tool to create database diagrams in postgreSQL

2012-12-28 Thread nevillekb
Hi, Can anyone tell me which free GUI based tools are available for creating database diagrams for my database in postgresql. Thanks, Neville. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-to-create-database-diagrams-in-postgreSQL-tp5738103.html Sent from the

Re: [GENERAL] Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Jaiswal Dhaval Sudhirkumar
"character_set_database"; -- Thanks & Regards Dhaval Jaiswal From: pgsql-general-ow...@postgresql.org on behalf of Adarsh Sharma Sent: Tue 3/1/2011 3:57 PM To: my...@lists.mysql.com Cc: pgsql-general@postgresql.org Subject: [GENERAL] Tool for shifting tables

Re: [GENERAL] Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Raghavendra
Hi Adarsh, There are very good tools out for migration from Mysql to PostgreSQL. EnterpriseDB has the migration studio which will help to migrate Mysql to PostgreSQL. http://www.enterprisedb.com/solutions/mysql-vs-postgresql/how-to-move-from-mysql-to-postgresql Best Regards, Raghavendra Enterpri

[GENERAL] Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Adarsh Sharma
Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). Can someone Please tell me tool for it that makes it easier. I am able to done it through FW tools in Windows System but i want to achieve it in Linux ( CentOS ) Syste

Re: [GENERAL] Tool for data modeling and ER diagram

2010-12-07 Thread Chris Browne
gwch...@gmail.com (Gary Chambers) writes: >> What is the best tool of data modeling and ER diagram for PostgreSQL. >> http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools > > Although it may not be considered a tool for use in the design (per > se) of a database, I would highly recommend that

Re: [GENERAL] Tool for data modeling and ER diagram

2010-12-07 Thread Gary Chambers
> What is the best tool of data modeling and ER diagram for PostgreSQL. > http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools Although it may not be considered a tool for use in the design (per se) of a database, I would highly recommend that SchemaSpy (http://schemaspy.sourceforge.net/) be

Re: [GENERAL] Tool for data modeling and ER diagram

2010-12-07 Thread Ben Chobot
On Dec 7, 2010, at 10:39 AM, Jaiswal Dhaval Sudhirkumar wrote: > Hi List, > > What is the best tool of data modeling and ER diagram for PostgreSQL. > http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools

Re: [GENERAL] Tool for data modeling and ER diagram

2010-12-07 Thread Dmitriy Igrishin
Hey Jaiswal, "Best" is relative word. It is matter of taste. I recommend dbWrench. http://www.dbwrench.com/ 2010/12/7 Jaiswal Dhaval Sudhirkumar > > Hi List, > > What is the best tool of data modeling and ER diagram for PostgreSQL. > > > -- > Thanks & Regards > DJ > > > The information transmi

[GENERAL] Tool for data modeling and ER diagram

2010-12-07 Thread Jaiswal Dhaval Sudhirkumar
Hi List, What is the best tool of data modeling and ER diagram for PostgreSQL. -- Thanks & Regards DJ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemi

Re: [GENERAL] Tool to compare data between tables

2010-08-23 Thread Arjen Nienhuis
http://phpsqldiff.sourceforge.net/ On Mon, Aug 23, 2010 at 4:32 PM, akp geek wrote: > Hi all - > > Is there any open source tool available for postgres to compare > data between 2 tables. Appreciate your help > > Regards >

[GENERAL] Tool to compare data between tables

2010-08-23 Thread akp geek
Hi all - Is there any open source tool available for postgres to compare data between 2 tables. Appreciate your help Regards

Re: [GENERAL] Tool for determining field usage of database tables

2010-02-25 Thread Scott Marlowe
On Thu, Feb 25, 2010 at 12:56 PM, Andy Yoder wrote: > Thanks Allan for the input - I guess I didn't specify enough details.  I am > looking for some type of tool/report that is already done.  We have nearly > 1000 tables, over 300 functions to look at a little over a day to provide the > answer

Re: [GENERAL] Tool for determining field usage of database tables

2010-02-25 Thread Andy Yoder
Yoder Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Tool for determining field usage of database tables Writing an audit trigger for the operations you'd like to monitor (then assign it to all your application's tables) to perform the auditing may be one easy way of doing so, t

[GENERAL] Tool for determining field usage of database tables

2010-02-25 Thread Andy Yoder
Does anyone know of a tool (or a way to use the database catalogs) that can analyze function code/queries accessing the database to pull out a list of the fields used in a set of tables. Basically we are importing a lot of data from another source, and we are trying to determine what percentage

Re: [GENERAL] Tool to converter plsql in pgplsql

2008-12-12 Thread Robert Treat
On Friday 12 December 2008 04:16:19 Dave Page wrote: > On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz wrote: > > paulo matadr wrote: > >> you knowns a tool for automatic converter plsql in pgplsql? > >> this tool exist? > > > > EnterpriseDB claim that they can do something like this, > > but I don

Re: [GENERAL] Tool to converter plsql in pgplsql

2008-12-12 Thread Dave Page
On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz wrote: > paulo matadr wrote: >> you knowns a tool for automatic converter plsql in pgplsql? >> this tool exist? > > EnterpriseDB claim that they can do something like this, > but I don't believe that there is any tool which can do > more than assist yo

Re: [GENERAL] Tool to converter plsql in pgplsql

2008-12-11 Thread Albe Laurenz
paulo matadr wrote: > you knowns a tool for automatic converter plsql in pgplsql? > this tool exist? EnterpriseDB claim that they can do something like this, but I don't believe that there is any tool which can do more than assist you. Yours, Laurenz Albe -- Sent via pgsql-general mailing list

[GENERAL] Tool to converter plsql in pgplsql

2008-12-11 Thread paulo matadr
Hi guys, you knowns a tool for automatic converter plsql in pgplsql? this tool exist? Thanks Paulo Moraes Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

Re: [GENERAL] Tool

2006-02-10 Thread Tino Wildenhain
Philippe Ferreira schrieb: > >> Thanks I am using pgadmin for development. I'm looking for a tool with >> which I can develop an interface that will be used for entering and >> accessing information in context with the user tasks. >> >> Bob > > > Hi, > > Why not OpenOffice "Base" ? Someone sho

Re: [GENERAL] Tool

2006-02-10 Thread Emi Lu
Could you suggests some tools that do not have to be super users to install it under Linux ? - Emi Thanks I am using pgadmin for development. I'm looking for a tool with which I can develop an interface that will be used for entering and accessing information in context with the user tasks.

Re: [Bulk] Re: [GENERAL] Tool

2006-02-10 Thread Ted Byers
Cheers,   Ted - Original Message - From: Bob Pawley To: Wes Williams ; 'Postgresql' Sent: Friday, February 10, 2006 1:03 PM Subject: [Bulk] Re: [GENERAL] Tool This looks quite interseting.   Thanks Wes   Bob - Original Message -

Re: [GENERAL] Tool

2006-02-10 Thread Philippe Ferreira
Thanks I am using pgadmin for development. I'm looking for a tool with which I can develop an interface that will be used for entering and accessing information in context with the user tasks. Bob Hi, Why not OpenOffice "Base" ? http://www.openoffice.org/product/base.html Philippe Fer

Re: [GENERAL] Tool

2006-02-10 Thread Jonel Rienton
resql Subject: Re: [GENERAL] Tool Thanks very much Tony. I'll give it a go. Bob - Original Message - From: "Tony Caduto" <[EMAIL PROTECTED]> Cc: "Postgresql" Sent: Friday, February 10, 2006 11:42 AM Subject: Re: [GENERAL] Tool > >> >>> >

Re: [GENERAL] Tool

2006-02-10 Thread Bob Pawley
Thanks very much Tony. I'll give it a go. Bob - Original Message - From: "Tony Caduto" <[EMAIL PROTECTED]> Cc: "Postgresql" Sent: Friday, February 10, 2006 11:42 AM Subject: Re: [GENERAL] Tool I am developing a database which needs testin

Re: [GENERAL] Tool

2006-02-10 Thread Tony Caduto
I am developing a database which needs testing prior to developing the host program. I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database. A GUI tool would be

Re: [GENERAL] Tool

2006-02-10 Thread Bob Pawley
This looks quite interseting.   Thanks Wes   Bob - Original Message - From: Wes Williams To: 'Bob Pawley' ; 'Postgresql' Sent: Friday, February 10, 2006 9:14 AM Subject: RE: [GENERAL] Tool You may wish to consider creating a web interf

Re: [GENERAL] Tool

2006-02-10 Thread Bob Pawley
> To: "Bob Pawley" <[EMAIL PROTECTED]> Cc: "Postgresql" Sent: Friday, February 10, 2006 9:30 AM Subject: Re: [GENERAL] Tool I am developing a database which needs testing prior to developing the host program. I am looking for an easy-to-learn tool. I want to de

Re: [GENERAL] Tool

2006-02-10 Thread Philippe Ferreira
I am developing a database which needs testing prior to developing the host program. I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database. A GUI tool would be ide

[GENERAL] Tool

2006-02-10 Thread Bob Pawley
I am developing a database which needs testing prior to developing the host program.   I am looking for an easy-to-learn tool. I want to develop an interface that I can use to enter and display information in a similar fashion to how a user would operate the database.   A GUI tool would be i

Re: [GENERAL] tool for DB design

2005-12-05 Thread William Bug
Hi Nikolay,Were you able to get any closer to your objective on this email thread?I spent quite a bit of time researching the web on this question back in June - Is there an Open Source option for doing "round trip" data modeling for PostgreSQL?As far as the E-R or UML diagramming, Dia and Umbrello

Re: [GENERAL] tool for DB design

2005-11-25 Thread John McCawley
I wrote a little LGPL app that generates Postgres SQL code from a graphical datamodel. It's not professional quality, but it functions. I don't actively maintain it, but I still use it for brainstorming datamodels and quick generation of the database. http://www.hardgeus.com/projects/pgdesig

Re: [GENERAL] tool for DB design

2005-11-25 Thread seem . iges
Hi, how about, dia - http://www.gnome.org/projects/dia/ have not used myself, but AFAIK UML diagrams are possible. umbrello - http://uml.sourceforge.net/index.php UML and ERD diagrams. regards, Iges. On Friday, 25. November 2005 12:01, Nikolay Samokhvalov wrote: > dbvis isn't the thing what I

Re: [GENERAL] tool for DB design

2005-11-25 Thread Tino Wildenhain
Nikolay Samokhvalov schrieb: dbvis isn't the thing what I need. Or I'm blind and cannot find where I can draw ER/UML diagram then transform it to physical, then obtain SQL code. Or, just physical->SQL. Please correct me if I'm wrong. Well, I mentioned DIA for this - reread my mail please ;) I s

Re: [GENERAL] tool for DB design

2005-11-25 Thread Oleg Bartunov
On Fri, 25 Nov 2005, Nikolay Samokhvalov wrote: dbvis isn't the thing what I need. Or I'm blind and cannot find where I can draw ER/UML diagram then transform it to physical, then obtain SQL code. Or, just physical->SQL. Please correct me if I'm wrong. Nikolaym, it's worth to look on Enterpris

Re: [GENERAL] tool for DB design

2005-11-25 Thread Nikolay Samokhvalov
dbvis isn't the thing what I need. Or I'm blind and cannot find where I can draw ER/UML diagram then transform it to physical, then obtain SQL code. Or, just physical->SQL. Please correct me if I'm wrong. On 25/11/05, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > Am Freitag, den 25.11.2005, 02:25 +

Re: [GENERAL] tool for DB design

2005-11-24 Thread Tino Wildenhain
Am Freitag, den 25.11.2005, 02:25 +0300 schrieb Nikolay Samokhvalov: > Please, suggest any free/opensource tool for DB design under Linux. I > need following: ER (or UML)-diagram -> physical diagram -> SQL code (I > don't even dream about reverse transformation...) Quite good example > of such tool

[GENERAL] tool for DB design

2005-11-24 Thread Nikolay Samokhvalov
Please, suggest any free/opensource tool for DB design under Linux. I need following: ER (or UML)-diagram -> physical diagram -> SQL code (I don't even dream about reverse transformation...) Quite good example of such tool is Sybase PowerDesigner (which supports Postgres), but AFAIK it runs only un

Re: [GENERAL] Tool for database design documentation?

2005-08-04 Thread littlebutty
Not a free utility, but a good one: http://www.datanamic.com/dezign/index.html ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your mes

Re: [GENERAL] Tool for database design documentation?

2005-07-31 Thread William Bug
I use a combination of the gnome-based diagraming application Dia (http://www.gnome.org/projects/dia/) and the tedia2sql diagram-to-DDL SQL translation script, which is written in Perl (http://tedia2sql.tigris.org/).It's a bit awkward, but:    1) Dia is a wonderful, open source diagramming tool I c

Re: [GENERAL] Tool for database design documentation?

2005-07-30 Thread Jeffrey Melloy
On Jul 30, 2005, at 2:30 PM, Jon Christian Ottersen wrote:We are trying to find a good way to document our database design – what is the rationale behind each table/field, what kind of information is each field supposed to contain, perhaps also something about the linking between the tables etc. Is

Re: [GENERAL] Tool for database design documentation?

2005-07-30 Thread Steve Manes
Jon Christian Ottersen wrote: We are trying to find a good way to document our database design – what is the rationale behind each table/field, what kind of information is each field supposed to contain, perhaps also something about the linking between the tables etc. Is there anybody who has s

[GENERAL] Tool for database design documentation?

2005-07-30 Thread Jon Christian Ottersen
We are trying to find a good way to document our database design – what is the rationale behind each table/field, what kind of information is each field supposed to contain, perhaps also something about the linking between the tables etc. Is there anybody who has some experience on this? Is

[GENERAL] tool for analysing the postgres log-file

2005-07-29 Thread Stefan Scherf
Hi, does anyone know a tool for analysing the postgres logfile? i want't to search for slow queries... thanks, stefan ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] tool for incrementally shrinking bloated tables

2004-12-22 Thread Martijn van Oosterhout
I like the idea generally, just some comments: On Tue, Dec 21, 2004 at 07:09:39PM -0500, Paul Tillotson wrote: > (1) VACUUM KEEP_EARLY_FREE_PAGES mybloatedtable; -- item (a) This may not be necessary anyway, but could improve performance. > (2) UPDATE mybloatedtable SET foo = foo WHERE ctid > '(

Re: [GENERAL] tool for incrementally shrinking bloated tables

2004-12-21 Thread Jim C. Nasby
On Tue, Dec 21, 2004 at 07:09:39PM -0500, Paul Tillotson wrote: > To use this system one would do this: > > (1) VACUUM KEEP_EARLY_FREE_PAGES mybloatedtable; -- item (a) > > (2) UPDATE mybloatedtable SET foo = foo WHERE ctid > '(n, 0)'; > --move tuples in end of the table to the front. > > (3

[GENERAL] tool for incrementally shrinking bloated tables

2004-12-21 Thread Paul Tillotson
(Originally posted on -hackers, but they were too busy or not interested.) I am thinking about attempting to code this if it is not too difficult for a newbie, but I wanted to see if anyone has any input or ideas first. Goal: on a prduction server, to gradually shrink a table (no matter how large

Re: [GENERAL] tool for postgresql

2004-11-29 Thread Johan Wehtje
10:20 AM *To:* [EMAIL PROTECTED] *Subject:* [GENERAL] tool for postgresql Hi, Any tool available for Postgresql for admin activities like TOAD ( which is used for oracle database).Appreciate if somebody let me know. Thanks in advance. ---(end of broa

Re: [GENERAL] tool for postgresql

2004-11-29 Thread Gevik Babakhani
Checkout http://www.pgadmin.org   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nageshwar Rao Sent: Monday, November 29, 2004 10:20 AM To: [EMAIL PROTECTED] Subject: [GENERAL] tool for postgresql   Hi, Any tool available for Postgresql for admin activities

[GENERAL] tool for postgresql

2004-11-29 Thread Nageshwar Rao
Hi, Any tool available for Postgresql for admin activities like TOAD ( which is used for oracle database).Appreciate if somebody let me know. Thanks in advance.

[GENERAL] Tool to ease development of plpgsql

2004-01-18 Thread Bill McMilleon
  What’s the best way to ease development of plpgsql.   My largest issues with plpgsql pertains to the quoting of course.   Bill McMilleon  

Re: [GENERAL] Tool to ease development of plpgsql

2004-01-18 Thread Dean Arnold
Would a tool like www.presicient.com/teraforge be of value ? I'm thinking of making a Pg portif interested, please let me know, and let me know what kind of features you'd like to see... -- Dean Arnold Presicient Corp. www.presicient.com "Richard Huxton" <[EMAIL PROTECTED]> wrote in message

[GENERAL] Tool to ease development of plpgsql

2004-01-18 Thread Bill McMilleon
What's the best way to ease development of plpgsql. My largest issues with plpgsql pertain to the quoting of course. Bill McMilleon ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining

[GENERAL] Tool to ease development of plpgsql

2004-01-16 Thread bill.postgresql-users
What's the best way to ease development of plpgsql. My largest issues with plpgsql pertain to the quoting of course. Bill McMilleon ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]