Good time of the day!
I'm a real novice to PostgreSQL, so please be patient with me :))
I've run into few questions I can't find answers to... Will appreciate
1. Is it possible to SELECT from two databases? Something like
SELECT db1.table1.field, db2.table1.fields ...
2. There is a table of the following structure:
CREATE TABLE test (
I need to get a list of different "string1" strings ordered by
"ord". But SELECT DISTINCT id, string1 ... ORDER BY ord" doesn't
work. Is there any way to get it?
3. I have two tables, say table1 and table2. Need to let web users
insert data into one of the tables. So far it's easy. Hard point:
web-user should be able insert rows into table1 and at the same time
update related rows in table2. And I need to maximally secure table2.
I've tried to create a view based on table1 and a set of rules, but
rules are applied with web username. So if I grant web users right to
update table2 than I can't protect this table; and if I don't grant
them those rights than I don't see a way to update rows in table2.
Question: is there a way to run rule on behalf of different user?
Something like setusername(user)?
PS. Will appreciate any points to docs on security of web access to
Dmitri ( mailto:dmitri(at)listsoft(dot)ru )
pgsql-novice by date
|Next:||From: GH||Date: 2000-11-26 02:02:20|
|Subject: Re: Couple simple(?) questions...|
|Previous:||From: Ron Chmara||Date: 2000-11-26 00:26:42|
|Subject: Re: [NOVICE] Re: re : PHP and persistent connections|