Hello,
I need to grant access to some records of ts table to
user psergio.
I created 2 views. psergio should be allowed to use select
only on one of them. But I removed access to the whole table.
So, although I grant access to va, it is denied because the
ts table is not acessible!
How can I tu
> > Is it possible to manipulate the way an index is created by using
> > functions?
Yes, it is possible:
\h create index
Command: create index
Description: construct an index
Syntax:
CREATE [UNIQUE] INDEX indexname ON class_name [USING access_method]
( attr1 [type_class1], ...attrN | f
> I also think the ticks that Michael is talking about are required. You can
> usually find more information about the "copy" error in the server.log
> (don't know where this is located on your system).
The file name must be enclosed in single closing quotes ('\047'). And
by the way, psql (if b
Hello,
I'm sorry if this is the 2nd post. I'm not sure if
it was sent the 1st time.
I need to grant access to some records of ts table to
user psergio.
I created 2 views. psergio should be allowed to use select
only on one of them. But I removed access to the whole table.
So, although I grant a
After an upgrade to redhat 5.2 from 5.0 ,when i start psql i get the message "Broken
Pipe"?
What does this mean?
chuck
Title: selects on datetime
Hello all,
I have a table w/ a field of type datetime. I would like to do something like:
select count(jobs) for every day of a particular month and year.
my current select statement is:
Select count(job_id) from jobs where date_part('month',sub_dt)=2 and date_pa
