Date: Thu, 14 Oct 2004 11:42:55 -0400 (EDT)
From: Christian Fowler <spider@viovio.com>
To: =?UTF-8?B?U8OtZGFyIExD?= <slopez_pg@ceroriesgo.co.cr>
Cc: postgresql <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL Tool?
In-Reply-To: <416E9B40.2030303@ceroriesgo.co.cr>
Message-ID: <Pine.LNX.4.61.0410141141230.15205@leda.steelsun.com>
References: <416E9B40.2030303@ceroriesgo.co.cr>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT


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@viovio.com
[ / \   http://www.viovio.com | http://www.tikipro.org
From pgsql-admin-owner@postgresql.org  Thu Oct 14 17:19:54 2004
X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5191932B404
	for <pgsql-admin-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.org>; Thu, 14 Oct 2004 17:19:47 +0100 (BST)
Message-ID: <20041014161946.26948.qmail@web50006.mail.yahoo.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@yahoo.com>
Subject: Re: Database schemas: search_path
To: pgsql-admin@postgresql.org
In-Reply-To: <20041014143432.GA25803@wolff.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@wolff.to> escribió: 
> On Thu, Oct 14, 2004 at 09:42:45 -0300,
>   Igor Maciel Macaubas <igor@providerst.com.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