PostgreSQL Cookbook

From Littledamien Wiki

Revision as of 19:36, 20 March 2015 by Video8 (talk | contribs) (→‎Creating a database)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Installation on Windows

Search for the "PostgreSQL Windows". There is an installer available. It's pretty straightforward.

Creating a database

Use the pgAdmin III program.

First create a Login Role for the database. Set the database's owner to the new (or existing) login role:
Object browser > Server Groups > [server] > Login Roles > (right click) > New Login Role
Create the database
Object browser > Server Groups > [server] > Databases > (right click) > New Database

Retrieved from "https://wiki.dbarchowsky.com/index.php?title=PostgreSQL_Cookbook&oldid=1396"