[ADMIN] Drop Schema from Postgres

[Tripura]

Hi,
I am trying to execute a few postgres commands from a bash file

I am trying to drop a schema by writing the following line

DROP SCHEMA "xxx" IF EXISTS

I have two issues here -
1> I am not sure how to specify the db from which the schema should be
deleted
2> I am getting the following error message -- "DROP: command not found"

Can anyone help me with this issue

Thanku in advance


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

[Kevin Grittner]

Post by Tripura
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";

Post by Tripura
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.

Post by Tripura
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;

-Kevin

[Walter Hurry]

Post by Kevin Grittner

Post by Tripura
I am trying to drop a schema by writing the following line
DROP SCHEMA "xxx" IF EXISTS

DROP SCHEMA IF EXISTS "xxx";

Post by Tripura
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.

Post by Tripura
2> I am getting the following error message -- "DROP: command not found"

Perhaps you should try this in an interactive session and paste the
ERROR: syntax error at or near "IF"
LINE 1: DROP SCHEMA "xxx" IF EXISTS;

He's not even in psql

[Tripura]

Hi,
I got the solution for this issue.
Thanku

Date: Thu, 5 Jan 2012 10:51:13 -0800
From: ml-node+***@n5.nabble.com
To: ***@hotmail.com
Subject: Re: Drop Schema from Postgres

Post by Kevin Grittner

Post by Tripura
I am trying to drop a schema by writing the following line
DROP SCHEMA "xxx" IF EXISTS

DROP SCHEMA IF EXISTS "xxx";

Post by Tripura
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.

Post by Tripura
2> I am getting the following error message -- "DROP: command not
found"

Perhaps you should try this in an interactive session and paste the
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.