Re: Two questions in a row

Renato Moutinho wrote:

> Hello people,
>
> I have two questions I would like to know if
> anyone can help me with:
>
> 1. How do you remove one of two identical rows
> from a pgsql table ?

DELETE FROM t1 WHERE .... wil do the stuff for you. If you don't know
the value into the duplicate field just export the database with pg_dump
create
a unique index onto this field and reimport all your data. Duplicate
data will
not be inserted.

> 2. How can I restrict connection to a certain
> database (locally) on a user basis ? I mean,
> I want to permit connection to mydb1 from user
> user1 only and connection to mydb2 from user
> user2 only..

See pg_hba.conf into your data directory, all is here...

> P.S.: Excuse me for the newbiness on any of
> these 2 questions.. :-)
>
> Thanks in advance,
>
> --
> Renato Moutinho Silva
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/