SEO

#1 (**permalink**) 04-09-2008, 05:23 PM

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2 (**permalink**) 04-09-2008, 05:23 PM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

deleting/dropping tables...