Unifix knowledge database - The original one

Dashboard - News - Search - List - About - Admin


Postgre quickguide

Author:mike - Tue Jan 8 14:00:56 2008

postgres@dev:~$ psql projektstyring
Welcome to psql 8.1.9, the PostgreSQL interactive terminal.

postgres@dev:~$ createdb projektstyring
CREATE DATABASE

projektstyring=# create user projektstyring with password 'kode';
CREATE ROLE

projektstyring=# GRANT ALL ON DATABASE projektstyring TO projektstyring;
GRANT


should be all that you need to continue from phppgadmin..

projektstyring=# create schema authorization projektstyring;
CREATE SCHEMA

projektstyring=# grant all on schema public to projektstyring;
GRANT
Copyright(c) Unifix.org 2002-2011


Dashboard - News - Search - List - About - Admin
 
Powered by Mikjaer Consulting Solutions - Hosted by Specialhosting.dk