Re: [JDBC] Schema?

From: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
To: "Ing(dot) Jhon Carrillo" <jdigital(at)cantv(dot)net>
Cc: pgadmin-support(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Schema?
Date: 2005-01-21 20:14:56
Message-ID: 41F162C0.2070101@akyasociados.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-jdbc pgsql-odbc

well, you could add the schemas you work with into your path. Just open
postgresql.conf, search for a line like this:
/search_path = '$user,public' # schema names/

and add your schema names to the list. This should do what you want.

Ing. Jhon Carrillo wrote:

> I want to make a query without to indicate the schema name, for example:
>
>
> Select * from tabla where ....
>
> and not
>
> select * from schema.tabla where ...
>
> not to show the shema or system tables from odbc and jdbc
>
> can you help me?
>
> thanks
>

In response to

  • Schema? at 2005-01-21 17:58:11 from Ing. Jhon Carrillo

Browse pgadmin-support by date

  From Date Subject
Next Message Vanole, Mike 2005-01-23 14:22:56 Viewing active queries
Previous Message Kris Jurka 2005-01-21 19:59:05 Re: [JDBC] Schema?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nico 2005-01-21 21:06:36 sql action command doesn't work
Previous Message Oliver Jowett 2005-01-21 20:07:05 Re: context classloader

Browse pgsql-odbc by date

  From Date Subject
Next Message Amadeo Garcia 2005-01-22 17:07:19 Error connecting a visual studio .NET "app" and PostgreSQL
Previous Message Kris Jurka 2005-01-21 19:59:05 Re: [JDBC] Schema?