X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 65088D1D300 for ; Sat, 6 Mar 2004 08:57:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12016-06 for ; Sat, 6 Mar 2004 04:57:44 -0400 (AST) Received: from elbereth.noviforum.si (unknown [193.189.169.66]) by svr1.postgresql.org (Postfix) with ESMTP id 733B1D1D315 for ; Sat, 6 Mar 2004 04:57:37 -0400 (AST) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i268saHh004964; Sat, 6 Mar 2004 09:54:36 +0100 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i268saKx004963; Sat, 6 Mar 2004 09:54:36 +0100 Date: Sat, 6 Mar 2004 09:54:36 +0100 From: Grega Bremec To: Ivan Dario Salazar Cc: pgsql-admin@postgresql.org Subject: Re: Postgresql functions Message-ID: <20040306085436.GA4909@elbereth.noviforum.si> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="bp/iNruPH9dso1Pn" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/89 X-Sequence-Number: 12658 --bp/iNruPH9dso1Pn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Wed, Mar 03, 2004 at 12:04:25AM +0000, Ivan Dario Salazar used th= e keyboard: > Hi there... >=20 > I write it becouse i need to know where can i get a "SPECIFIC DOCUMENT"= =20 > with the "Postgresql Administration Functions" like >=20 > - Create User > - Create Group Hello Ivan, There are a couple of options for you. First off, there is this thing called "PostgreSQL Documentation", it is a part of the source distribution, but it can also be downloaded separately, the file is called postgresql-docs-.tar.bz2 in the PostgreSQL download archives, and it documents all SQL commands available to the user in much detail in subsection 7.1, "VI. Reference / I. SQL Commands". If you're interested in a text focusing more on user and privilege administration, you can also take a look at chapter 17., "Database users and Privileges" of that same documentation bundle. One very convenient option would be using the \h internal slash command of your psql command-line client. Try "\h" on the line alone to get a full list of SQL commands you have help available on, then, use, for example, template1=3D# \h CREATE USER Command: CREATE USER Description: define a new database user account Syntax: CREATE USER name [ [ WITH ] option [ ... ] ] where option can be: =09 SYSID uid=20 | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | IN GROUP groupname [, ...] | VALID UNTIL 'abstime' Hope this helped. --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --bp/iNruPH9dso1Pn Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFASZHMDo/EMYD4+osRAsQ/AKCIgPIAgChf5pfVEWddFTio/usTcACfdrJA Vw3UIi0R5esRziXWtyn0auQ= =b2LT -----END PGP SIGNATURE----- --bp/iNruPH9dso1Pn--