Date: Thu, 5 Jan 2012 10:51:13 -0800 From: [hidden email] To: [hidden email] Subject: Re: Drop Schema from Postgres
On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote:
> Tripura <[hidden email]> wrote: > >> I am trying to drop a schema by writing the following line >> >> DROP SCHEMA "xxx" IF EXISTS > > The syntax requires: > DROP SCHEMA IF EXISTS "xxx"; > >> I have two issues here - >> 1> I am not sure how to specify the db from which the schema should be >> deleted > > You connect to a particular database. All operations are against that > database. > >> 2> I am getting the following error message -- "DROP: command not >> found" > > Perhaps you should try this in an interactive session and paste the > actual error lines. I get this: > > ERROR: syntax error at or near "IF" > LINE 1: DROP SCHEMA "xxx" IF EXISTS;