PostgreSQL Cookbook: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:PostgreSQL Category:Django Category:Pyton Category:Web Development == Installation on Windows == Search for the "PostgreSQL Windows". There is an ins...") |
|||
| Line 5: | Line 5: | ||
== Creating a database == | == 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:<br />'''Object browser''' > '''Server Groups''' > ''[server]'' > '''Login Roles''' > ''(right click)'' > '''New Login Role''' | |||
* Create the database<br />'''Object browser''' > '''Server Groups''' > ''[server]'' > '''Databases''' > ''(right click)'' > '''New Database''' | |||
Revision as of 19:36, 20 March 2015
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