From owner-freebsd-database Sat Jan 20 10:36:54 2001 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (SHW2-220.accesscable.net [24.71.145.220]) by hub.freebsd.org (Postfix) with ESMTP id B5AD237B404 for ; Sat, 20 Jan 2001 10:36:36 -0800 (PST) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.11.1/8.11.1) with ESMTP id f0KIW6b21788; Sat, 20 Jan 2001 14:32:06 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Sat, 20 Jan 2001 14:32:05 -0400 (AST) From: The Hermit Hacker To: Francisco Reyes Cc: Subject: Re: Need help with PostgreSQL database In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Sat, 20 Jan 2001, Francisco Reyes wrote: > On Thu, 18 Jan 2001, The Hermit Hacker wrote: > > > do a 'psql template1' ... from there, you can do a 'create database' or > > 'create user' to build ... > > What is the difference with doing it that way and using "createdb"? > Although I am sure what you suggest is likely the right way, I wonder why > both the tutorial and the book I got don't mention it. createdb is a shortcut to do the same thing ... if you want to do stuff like create new users or create new databases, you can call the "proper SQL" from places like PHP and perl, especially when your admin is on one machine, vs your server on a different one ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message