Re: [ADMIN] Drop Schema from Postgres

2012-01-08 Thread Tripura
Hi, I got the solution for this issue. Thanku Date: Thu, 5 Jan 2012 10:51:13 -0800 From: ml-node+s1045698n5123527...@n5.nabble.com To: k_trip...@hotmail.com Subject: Re: Drop Schema from Postgres On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote: Tripura [hidden email]

[ADMIN] Drop Schema from Postgres

2012-01-05 Thread 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

Re: [ADMIN] Drop Schema from Postgres

2012-01-05 Thread Kevin Grittner
Tripura k_trip...@hotmail.com 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

Re: [ADMIN] Drop Schema from Postgres

2012-01-05 Thread Walter Hurry
On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote: Tripura k_trip...@hotmail.com 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