Thread: deleting/dropping tables...

Hi..

New to postgres. I'm trying to install an app that uses postgres for the db.

I'm trying to resinstall the db/sql, and it's generating a great deal of
errors. I figured the easy solution would be to delete/drop the
database/tables, but when i did a :
 drop database gforge;

the gforge database is still in the database list when i do a "psql \l"

some of the sites i've seen reference a "template1"

any pointers to how to drop a database, as well as how to drop/delete all
the tables in a postgres db...

thanks

-bruce

bruce wrote:
> I'm trying to resinstall the db/sql, and it's generating a great deal of
> errors. I figured the easy solution would be to delete/drop the
> database/tables, but when i did a :
>  drop database gforge;
>
> the gforge database is still in the database list when i do a "psql \l"

Then you should have got an error back from your "drop database" command.

--
   Richard Huxton
   Archonet Ltd