Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9BC32477712 for ; Tue, 28 Jan 2003 22:12:47 -0500 (EST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by postgresql.org (Postfix) with ESMTP id 14A3547929F for ; Tue, 28 Jan 2003 20:46:22 -0500 (EST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.6/8.12.6) with ESMTP id h0T1j43c004954; Tue, 28 Jan 2003 18:45:04 -0700 (MST) Date: Tue, 28 Jan 2003 18:40:12 -0700 (MST) From: "scott.marlowe" To: "_root.paulSutcliffe" Cc: Subject: Re: how to start with postgreSQL? In-Reply-To: <20030128233952.21400.qmail@web12705.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailScanner: Found to be clean X-MailScanner-SpamCheck: X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/83 X-Sequence-Number: 1828 On Tue, 28 Jan 2003, _root.paulSutcliffe wrote: > > how can I do to create users, create a data base and make it work in > postgreSQL? I can do it on mySQL but not in postgreSQL , they are not > supossed to be the same? I have php 4 in mandrake 9 , and i'm doing > local tests on my pc , but i don't have lan, i will apreciate the help > of anyone who helps me. No, they're not the same, and sadly for your future database experiences, this is one area in which most databases are not the same. you'll need to take a quick tour of the administrators guide: http://www.postgresql.org/docs/view.php?version=7.3&file=admin.html the quick skinny is that you can use the command line tools as the postgres super user (su - to root, then su - to postgres) to create databases and users to start. createuser createdb should work. but you really need to read the administrators guide a bit to get a feel for the things you'll likely need to know. We'll teach ya to fish, we won't fish for ya...