| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Carlos Alberto Mÿffffffffffe1rquez Rey <carlos_marquez_rey(at)yahoo(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Consulta al usar Esquemas - Continua |
| Date: | 2005-07-13 22:45:27 |
| Message-ID: | 20050713224527.GA11247@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On Wed, Jul 13, 2005 at 05:36:50PM -0500, Carlos Alberto Mÿffffffffffe1rquez Rey wrote:
> e usado esta linea
> SET search_path TO su_maestros_sis,public;
>
> despues esta para ver los cambios
> SHOW search_path;
>
> muestra
> "su_maestros_sis, public"
>
> pero la aplicacion me sigue diciendo que la tabla no
> existe, a menos que le ponga el esquema adelante.
Works For Me:
alvherre=# create schema authorization alvherre;
CREATE SCHEMA
alvherre=# set search_path to 'alvherre', 'public';
SET
alvherre=# create table alvherre.test ();
CREATE TABLE
alvherre=# select * from test;
--
(0 filas)
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan Pablo GO | 2005-07-13 22:53:38 | Re: Mostrar columnas de tabla determinada |
| Previous Message | Carlos Alberto Mÿffffffffffe1rquez Rey | 2005-07-13 22:36:50 | Consulta al usar Esquemas - Continua |