From paulyoyo@yahoo.com Wed Jan 29 01:21:31 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 824B74777D5 for ; Tue, 28 Jan 2003 20:21:31 -0500 (EST) Received: from web12705.mail.yahoo.com (web12705.mail.yahoo.com [216.136.173.242]) by postgresql.org (Postfix) with SMTP id 95BF4476B1E for ; Tue, 28 Jan 2003 18:39:49 -0500 (EST) Message-ID: <20030128233952.21400.qmail@web12705.mail.yahoo.com> Received: from [200.60.237.16] by web12705.mail.yahoo.com via HTTP; Tue, 28 Jan 2003 15:39:52 PST Date: Tue, 28 Jan 2003 15:39:52 -0800 (PST) From: "_root.paulSutcliffe" Reply-To: paulyoyo@yahoo.com Subject: how to start with postgreSQL? To: pgsql-php@postgresql.org In-Reply-To: <000b01c2c3d2$0d80f9a0$790aa3d5@compax> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-88821889-1043797192=:20839" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/82 X-Sequence-Number: 1827 --0-88821889-1043797192=:20839 Content-Type: text/plain; charset=us-ascii 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. --------------------------------- _root.paulSutcliffe; --------------------------------- Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now --0-88821889-1043797192=:20839 Content-Type: text/html; charset=us-ascii

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.




_root.paulSutcliffe;

 



Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now --0-88821889-1043797192=:20839-- From scott.marlowe@ihs.com Wed Jan 29 03:12:47 2003 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... From chriskl@familyhealth.com.au Wed Jan 29 04:13:34 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7083E47644B for ; Tue, 28 Jan 2003 23:13:34 -0500 (EST) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by postgresql.org (Postfix) with ESMTP id 96CE8476070 for ; Tue, 28 Jan 2003 22:13:43 -0500 (EST) Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6/8.11.6) id h0T3DjL15452 for pgsql-php@postgresql.org; Wed, 29 Jan 2003 11:13:45 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6/8.9.3) with SMTP id h0T3DhF15363; Wed, 29 Jan 2003 11:13:43 +0800 (WST) From: "Christopher Kings-Lynne" To: , Subject: Re: how to start with postgreSQL? Date: Wed, 29 Jan 2003 11:14:24 +0800 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0002_01C2C787.946A44E0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal In-Reply-To: <20030128233952.21400.qmail@web12705.mail.yahoo.com> X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/85 X-Sequence-Number: 1830 This is a multi-part message in MIME format. ------=_NextPart_000_0002_01C2C787.946A44E0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit No, they are not supposed to be the same. Use the 'createdb' and 'createuser' command-line programs to set it up. Or even read the manual... Chris -----Original Message----- From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]On Behalf Of _root.paulSutcliffe Sent: Wednesday, 29 January 2003 7:40 AM To: pgsql-php@postgresql.org Subject: [PHP] how to start with postgreSQL? 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. ---------------------------------------------------------------------------- -- _root.paulSutcliffe; ---------------------------------------------------------------------------- -- Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ------=_NextPart_000_0002_01C2C787.946A44E0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
No,=20 they are not supposed to be the same.  Use the 'createdb' and 'createu= ser'=20 command-line programs to set it up. Or even read the=20 manual...
 
Chris
-----Original Message-----
From:=20 pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]= On=20 Behalf Of _root.paulSutcliffe
Sent: Wednesday, 29 January 2= 003=20 7:40 AM
To: pgsql-php@postgresql.org
Subject: [PHP] h= ow to=20 start with postgreSQL?

how can I do to create users, create a data base= and=20 make it work in postgreSQL? I can do it on mySQL but not in postg= reSQL=20 , they are not supossed to be the same? I have php 4 in mandrake 9= ,=20 and i'm doing local tests on my pc , but i don't have lan, i will a= preciate=20 the help of anyone who helps=20 me.




_root.paulSutcliffe;
=20

 



Do you Yahoo!?
Yaho= o! Mail=20 Plus - Powerful. Affordable. Sign= up=20 now ------=_NextPart_000_0002_01C2C787.946A44E0-- From randy@icecoldgold.com Wed Jan 29 08:23:06 2003 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 57BEA479B7D for ; Wed, 29 Jan 2003 03:23:06 -0500 (EST) Received: from digital.dgc-ads.com (unknown [64.141.71.90]) by postgresql.org (Postfix) with ESMTP id 22BC8479E7C for ; Wed, 29 Jan 2003 01:47:14 -0500 (EST) Received: from CPQ63206056281 ([207.144.44.186]) by digital.dgc-ads.com (8.12.6/8.12.6) with SMTP id h0T6lkiE012091 for ; Tue, 28 Jan 2003 22:47:48 -0800 MIME-Version: 1.0 Message-Id: <3E3778CD.0000A9.00616@CPQ63206056281> Date: Wed, 29 Jan 2003 01:46:37 -0500 (Eastern Standard Time) Content-Type: Text/Plain X-Mailer: IncrediMail 2001 (1850912) From: "Randy Johnson" References: X-FID: FLAVOR00-NONE-0000-0000-000000000000 X-FVER: 3.0 X-CNT: ; Content-Transfer-Encoding: quoted-printable X-Priority: 3 To: Subject: Re: how to start with postgreSQL? X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/3 X-Sequence-Number: 1854 My email is now catch all and do not know which one i used to subscribe to this list. How do I ger unsubscribed?=0D =0D Randy