See create_user(l) man page
or
use the CREATE USER sql...
$ psql template1
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
template1=# \h create user
Command: CREATE USER
Description: Creates a new database user
Syntax:
CREATE USER username
[ WITH
[ SYSID uid ]
[ PASSWORD 'password' ] ]
[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
[ IN GROUP groupname [, ...] ]
[ VALID UNTIL 'abstime' ]
template1=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3
(1 row)
template1=#
sherwin
[EMAIL PROTECTED] writes:
>
> hello guyz ;)
>
> pano ko i-aadd ang username sa postgres.. i mean yong trusted user
>to use the database.. sang file doon? sa pg_shadow? or pg_pwd?, kasi pag
>e-nedit mo naman yong pg_shadow eh garbage... ;(, pano po ba yon mga bro..
>and sis.. thankz for the help ;)
>
> God bless..
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
