Re: Drop Schema from Postgres

Hi,
I got the solution for this issue.
Thanku

Date: Thu, 5 Jan 2012 10:51:13 -0800
From: ml-node+s1045698n5123527h28(at)n5(dot)nabble(dot)com
To: k_tripura(at)hotmail(dot)com
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;

He's not even in psql

--

Sent via pgsql-admin mailing list ([hidden email])

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-admin

If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/Drop-Schema-from-Postgres-tp5118072p5123527.html



To unsubscribe from Drop Schema from Postgres, click here.

NAML

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Drop-Schema-from-Postgres-tp5118072p5123827.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.