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; -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
