Re: PostgreSQL Tool?

http://www.thekompany.com/products/dataarchitect/

Is an awesome tool. The "Reverse Engineer" ability will build the model
from an existing database.

On Thu, 14 Oct 2004, [UTF-8] Sídar LC wrote:

> Where can i find a tool for print graphical PostgreSQL schemas?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

[ \ /
[ >X< Christian Fowler | spider(at)viovio(dot)com
[ / \ http://www.viovio.com | http://www.tikipro.org
>From pgsql-admin-owner(at)postgresql(dot)org Thu Oct 14 17:19:54 2004
X-Original-To: pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 5191932B404
for <pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Thu, 14 Oct 2004 17:19:53 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 61350-08
for <pgsql-admin-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Thu, 14 Oct 2004 16:19:49 +0000 (GMT)
Received: from web50006.mail.yahoo.com (web50006.mail.yahoo.com [206.190.38.21])
by svr1.postgresql.org (Postfix) with SMTP id 252F732B1D5
for <pgsql-admin(at)postgresql(dot)org>; Thu, 14 Oct 2004 17:19:47 +0100 (BST)
Message-ID: <20041014161946(dot)26948(dot)qmail(at)web50006(dot)mail(dot)yahoo(dot)com>
Received: from [200.93.192.137] by web50006.mail.yahoo.com via HTTP; Thu, 14 Oct 2004 11:19:46 CDT
Date: Thu, 14 Oct 2004 11:19:46 -0500 (CDT)
From: Jaime Casanova <systemguards(at)yahoo(dot)com>
Subject: Re: Database schemas: search_path
To: pgsql-admin(at)postgresql(dot)org
In-Reply-To: <20041014143432(dot)GA25803(at)wolff(dot)to>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level:
X-Archive-Number: 200410/183
X-Sequence-Number: 15176

--- Bruno Wolff III <bruno(at)wolff(dot)to> escribió:
> On Thu, Oct 14, 2004 at 09:42:45 -0300,
> Igor Maciel Macaubas <igor(at)providerst(dot)com(dot)br>
> wrote:
> > Hi all,
> >
> > I've organized my database design in multiple
> schemas, and migrated my existing tables to
> different schemas by using a simple how-to I found
> in this list history.
> > But what I couldn't find was a way to make this
> schemata fully transparent to my application - which
> does selects directly to tables instead to
> schema.table. I know that I can always set the
> search_path environmnet variable, but I have to do
> it on each session. I'd like to know if there is a
> way to make my set search_path persistent on the
> database, no matter the session.
> > I believe that this is supported, but couldn't
> find out how to make it. Can someone help me?
>
> Use ALTER DATABASE to set per database defaults.
>

Hi,
set the parameter in the postgresql.conf

Regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com