Re: psql "SCHEMA" switch

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Paul Silveira <plabrh1(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql "SCHEMA" switch
Date: 2006-12-23 00:59:08
Message-ID: 73998921-2665-4F19-B94D-08083B19EFD3@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Dec 22, 2006, at 15:15 , Paul Silveira wrote:

> I wanted to connect to a DB and then insert that new DDL into a
> "specific"
> schema. 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.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2006-12-23 01:21:13 Re: Functions on tables
Previous Message Shoaib Mir 2006-12-22 21:23:16 Re: psql "SCHEMA" switch