From: Grega Bremec <gregab@noviforum.si>
To: Ivan Dario Salazar <ivansala6@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql functions
Date: Sat, 6 Mar 2004 09:54:36 +0100
Message-ID: <20040306085436.GA4909@elbereth.noviforum.si> (raw)
In-Reply-To: <Law10-F23CaPI3dLZpS0003c6ac@hotmail.com>
References: <Law10-F23CaPI3dLZpS0003c6ac@hotmail.com>
...and on Wed, Mar 03, 2004 at 12:04:25AM +0000, Ivan Dario Salazar used the keyboard:
> Hi there...
>
> I write it becouse i need to know where can i get a "SPECIFIC DOCUMENT"
> with the "Postgresql Administration Functions" like
>
> - 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-<version>.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=# \h CREATE USER
Command: CREATE USER
Description: define a new database user account
Syntax:
CREATE USER name [ [ WITH ] option [ ... ] ]
where option can be:
SYSID uid
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| IN GROUP groupname [, ...]
| VALID UNTIL 'abstime'
Hope this helped.
--
Grega Bremec
Senior Administrator
Noviforum Ltd., Software & Media
http://www.noviforum.si/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: gregab@noviforum.si, ivansala6@hotmail.com
Subject: Re: Postgresql functions
In-Reply-To: <20040306085436.GA4909@elbereth.noviforum.si>
References: <Law10-F23CaPI3dLZpS0003c6ac@hotmail.com> <20040306085436.GA4909@elbereth.noviforum.si>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox