How can I create a Postgres database in Perl?

Question

How can I create a Postgres database from Perl? This is not documented in the Perl Postgres DBI driver DBD::Pg (or pretty much anywhere else). I need to be able to create a scratch database from my program, rather than having to use psql or pgAdmin to create the database.

Community · Accepted Answer · 2017-05-23 12:07:52Z

5

The trick is using the 'postgres' database that you will likely have with your installation of Postgres (if you don't have a 'postgres' database, you probably know why). If you connect as user 'postgres' to the 'postgres' database, you can then issue then create database SQL command, like so:

my $dbh = DBI->connect("dbi:Pg:dbname=postgres", "postgres");
$dbh->do('create database "Scratch-School"');

(You might also look at create a postgreSQL database programmatically, which covers this issue at a higher level.)

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Sep 18, 2014 at 13:25

Mark Leighton Fisher

5,7332 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user330315 Over a year ago

You should stay away from quoted identifiers like "Scratch-School". Many tools have problems with that. Better use create database scratch_school making the name case-insensitive and doesn't require you to write those double quotes every time.

Daniel Vérité Over a year ago

The point is that to create a database, you need to be connected first to another existing database. It doesn't have to be postgres, and it's not specific to Perl. It's true even with psql, and even for createdb itself.

Collectives™ on Stack Overflow

How can I create a Postgres database in Perl?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related