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]> w

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 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 s

Re: [ADMIN] Drop Schema from Postgres

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

[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