Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: psql "SCHEMA" switch
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
- Cc: Paul Silveira <plabrh1(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: psql "SCHEMA" switch
- Date: Fri, 22 Dec 2006 22:58:37 -0500
Michael Glaesemann <grzm(at)seespotcode(dot)net> writes: > On Dec 22, 2006, at 15:15 , Paul Silveira wrote: >> Because psql does not have a schema switch, I had to do it this way... > As the schema is part of the DDL, I think it's better to have it as > part of DDL script rather than a switch for psql, either as schema- > qualified tables in the script or using a SET search_path command in > the SQL script. Besides, you can get the effect already via PGOPTIONS: PGOPTIONS="--search_path=myschema,yourschema" psql ... regards, tom lane
- References:
- psql "SCHEMA" switch
- From: Paul Silveira
- Re: psql "SCHEMA" switch
- From: Michael Glaesemann
- psql "SCHEMA" switch
- Prev by Date: Re: Problem with index in OR'd expression
- Next by Date: Clustering & Load Balancing & Replication
- Previous by thread: Re: psql "SCHEMA" switch
- Next by thread: Clustering & Load Balancing & Replication
- Indexes: