Обсуждение: How to delete databases from PostGreSQL?

Hi there,

I have around 10 databases in my PostGreSQL database, but i want to delete some of those im not using.
I've looked, but i have no clue how to delete them?

Can you give me any information or a guideline to make this possible for a computer noob.

Regards,
Ruud

On 4 January 2011 14:18, Ruud van Dijk <ruud_v_dijk@hotmail.com> wrote:
> Hi there,
>
> I have around 10 databases in my PostGreSQL database, but i want to delete
> some of those im not using.
> I've looked, but i have no clue how to delete them?
>
> Can you give me any information or a guideline to make this possible for a
> computer noob.

Just as you use CREATE DATABASE to create it, you can use DROP
DATABASE to remove it.

Read the documentation page about DROP DATABASE:
http://www.postgresql.org/docs/current/static/sql-dropdatabase.html

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

On Tue, 2011-01-04 at 15:18 +0100, Ruud van Dijk wrote:
>
> I have around 10 databases in my PostGreSQL database, but i want to
> delete some of those im not using.
> I've looked, but i have no clue how to delete them?

Connect to server using a client, and execute

DROP DATABASE database_name;

Alternatively, You can use pgadmin3 as GUI, which will let you drop a
database with a right click. http://www.pgadmin.org

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz