How to remove a schema in catalogs from a database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • datactrl
    New Member
    • Jul 2008
    • 51

    How to remove a schema in catalogs from a database

    When I install pgagent, I make a mistake to create a pgagent schema in catalogs in wrong database, by running an installation script, rather than in database of postgres. How can I remove it? On pgAdmin3, right click on pgagent schema in catalogs, there is no drop command.
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    You can always remove a schema using SQL command
    Code:
    drop schema <schema_name>;

    Comment

    • datactrl
      New Member
      • Jul 2008
      • 51

      #3
      Thank you,rski. It works!

      Comment

      Working...