On Thu, 05 Jan 2012 10:22:59 -0600, Kevin Grittner wrote: > Tripura <k_tripura@xxxxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin