Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-jdbcpgsql-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

pgsql-odbc by date

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

pgadmin-support by date

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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group