473,750 Members | 2,571 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Visual database structure browser for postgresql?

Hello

I am looking for something like visual database structure browser. I
need to see all tables and relations beetween them. Something like
"Relations" window in Microsoft database products (ex. msaccess).

I have to work with complicated database and i need to understand fast
how it works.

Greetings,

Bart

Nov 11 '05 #1
3 2316
> I am looking for something like visual database structure browser. I
need to see all tables and relations beetween them. Something like
"Relations" window in Microsoft database products (ex. msaccess)


Hi,

Try dbVisualizer: http://www.minq.se/products/dbvis/

You can view the relations, but cannot save the view though (it's in
the works apparently).

Cheers.

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #2
Take a look at:

http://www.datanamic.com/

the two products you'll need are the importer and dezign

Bart wrote:
Hello

I am looking for something like visual database structure browser. I
need to see all tables and relations beetween them. Something like
"Relations" window in Microsoft database products (ex. msaccess).

I have to work with complicated database and i need to understand fast
how it works.

Greetings,

Bart
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #3
Hello Bart,

please feel free to try our CASE Studio 2

http://www.casestudio.com

this database design tool allows you to reverse
engineer already existing database structures
and display all the tables, relationships etc.
Of course, you can generate SQL scripts and/or
very detailed HTML/RTF reports also.
The demo version has no time limitation and
you can load and browse whole the structure
at once.

Regards,

Vaclav Frolik
CHARONWARE, s.r.o.
Nov 11 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2232
by: Brent Ritchie | last post by:
Hello, My name is Brent Ritchie. I am starting a project for my family as a christmas present. What I want to do is create a lightweight database of my family tree, and allow family members to run a web service locally in thier browser. Because of it being local I don't want them to have to install a perl or PHP server or a database server on thier machines. So I looked to XML, which I am very new to. What I want to know is it possible...
8
4399
by: Gail Zacharias | last post by:
I am investigating the possibility of using pgsql as the database in an application. I have some unusual requirements that I'd like to ask you all about. I apologize in advance if my terminology is a little "off", I'm not familiar with pgsql (yet). I need to be able to move the database files, as normal user-visible files, between machines. I.e. given a database on machine A, I want to be able to copy either a single file (ideally) or a...
4
2365
by: Russell Crosser | last post by:
I maintain an internet site. The host is linux based and uses postgres on the server. I wish to install a smallish database (of names and addresses +) on the host, and allow it to be accessed over the internet (by a restricted number of people). I have the database working locally on a MS Access database, but would expect to transfer it to a postgresql database on the server. My question is: What is the method of operating such a database...
4
1660
by: Octavio Alvarez | last post by:
Hi! I would like to implement a database which allows me to keep track of changes from users, but I don't know if there is any model already used for this. Let me show you what I mean. Say I have a table t_table1 with 2 columns plus a PK. Normally my table with some data would look like: t_table1 ------------------ PK | col1 | col2
2
1485
by: William Herring | last post by:
I would like to set up a zope/database interface (using Postgres 7.4) with the following properties: - multiple users each with their own id and password - accessed via zope - they will enter and access their own data via zope to Postgresql - any specific user will not be able to see another user's data - the user will not manage his/her web-page I have Zope 2.6 and Postgres 7.4 set up and working with each other. Also, have a few...
3
2151
by: Rod Early | last post by:
I have the task of converting a SQL Server 2000 database to PostgreSQL. The data itself does not need to be converted, but the structure and stored procedures must be. I expect that converting tables and views will be simple. I expect that converting stored procedures and user-defined functions from T-SQL to PostgreSQL will be more complex. In any case, I am looking for recommendations and counsel regarding my expectations. I have...
19
2757
by: Andy B | last post by:
Hello, Sorry for this newbish question. Briefly, my problem: ------------------ I expect the database I'm working on to reach something in the order of 12-16 Gigabytes, and I am interested in understanding as much as I can about how I can make this go as fast as possible on a linux system. I haven't run such a large database before. The nature of the database is such that
2
12940
by: Daron | last post by:
Hi, Can anyone suggest any websites that might help with connecting visual studio dot net (I would like to see it running using server explorer if possible) to postgresql. I am planning to write some client applications in VB or C#. Regards, Daron.
221
367625
Atli
by: Atli | last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application needs to store entire files, the preferred method is to save the file onto the server’s file-system, and store the physical location of the file in your database. This is generally considered to be the easiest and fastest way to store files. ...
0
9001
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9396
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9342
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9256
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8263
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6081
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4888
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3323
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2807
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.