Postgres Pro
Downloads
Home   >   mailing lists

Re: Create user/create database outside template1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Create user/create database outside template1
Date
Msg-id 23541.959274316@sss.pgh.pa.us
Whole thread Raw
In response to Re: Create user/create database outside template1  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Create user/create database outside template1  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Well, thanks.  I was going over that for my book.  If I do createdb from
> another database, I guess I get a copy of that database, right? 

No, it's always a copy of template1.  CREATE DATABASE really doesn't
care which database you're connected to (nor does CREATE USER).
        regards, tom lane

pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: Create user/create database outside template1
Next
From: Bruce Momjian
Date:
Subject: Re: Create user/create database outside template1