pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql functions
2+ messages / 2 participants
[nested] [flat]

* Postgresql functions
@ 2004-03-03 00:04 Ivan Dario Salazar <ivansala6@hotmail.com>
  2004-03-06 08:54 ` Re: Postgresql functions Grega Bremec <gregab@noviforum.si>
  0 siblings, 1 reply; 2+ messages in thread

From: Ivan Dario Salazar @ 2004-03-03 00:04 UTC (permalink / raw)
  To: pgsql-admin

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
.......
.......
......
.....

etc.

I just need a Document which explains very shortly every function(as 
administrator).


Thanks for your Help.

PD. I really need it.

_________________________________________________________________
Charla con tus amigos en lĂ­nea mediante MSN Messenger: 
http://messenger.latam.msn.com/




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgresql functions
  2004-03-03 00:04 Postgresql functions Ivan Dario Salazar <ivansala6@hotmail.com>
@ 2004-03-06 08:54 ` Grega Bremec <gregab@noviforum.si>
  0 siblings, 0 replies; 2+ messages in thread

From: Grega Bremec @ 2004-03-06 08:54 UTC (permalink / raw)
  To: Ivan Dario Salazar <ivansala6@hotmail.com>; +Cc: pgsql-admin

...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/

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-03-06 08:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-03 00:04 Postgresql functions Ivan Dario Salazar <ivansala6@hotmail.com>
2004-03-06 08:54 ` Grega Bremec <gregab@noviforum.si>

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