Im having a little problem. First let me say im a total newbie as far as
sys-admin and such. Normally Im just a production guy. But as of late im
starting to have more responsibilties, backup, set up new clients, etc.
so please bear with me in my detail I just dont know what info you need
and
On Thu, Nov 04, 2004 at 05:07:20PM -0700, David Bear wrote:
>
> npcenter=# grant all on table 'contactNames' to group npcenter;
> ERROR: syntax error at or near "'contactNames'" at character 20
Try double quotes:
grant all on table "contactNames" to group npcenter;
http://www.postgresql.org/doc
On Thu, 4 Nov 2004, David Bear wrote:
> I'm using pg 7.3 on freebsd..
>
> I've created a database use sql.
>
> now, as the pg superuser I cant seem to grant any permissions on the
> tables in the db..
>
> npcenter-# \z
> Access privileges for database "npcenter"
> Schema |Table | Access
I'm using pg 7.3 on freebsd..
I've created a database use sql.
now, as the pg superuser I cant seem to grant any permissions on the
tables in the db..
npcenter-# \z
Access privileges for database "npcenter"
Schema |Table | Access privileges
+--+---
Thanks! for all the quick replies, looks like it is better to install
all the packages as our environment needs all of them. I was under the
impression that
(postgresql-7.4.6-2PGDG.i686.rpm or
postgresql-server-7.4.6-2PGDG.i686.rpm ) one of these packages is the
super set of all the packages an
Pallav Kalva wrote:
> How do i know which one is for installing the Postgres server and
> what are the other packages for ?
rpm -qpi packagefile
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 4 Nov 2004, Pallav Kalva wrote:
I am installing Postgres for the first time on my Linux machine , I found
the following RPM packages for the RedHat 9
postgresql-7.4.6-2PGDG.i686.rpm postgresql-contrib-7.4.6-2PGDG.i686.rpm
postgresq
Pallav Kalva <[EMAIL PROTECTED]> writes:
> How do i know which one is for installing the Postgres server and
> what are the other packages for ?
You could read the package descriptions ...
> do i have to install all these packages too ?
Might as well. The ones that could reasonably be cons
Hi,
I am installing Postgres for the first time on my Linux machine , I
found the following RPM packages for the RedHat 9
postgresql-7.4.6-2PGDG.i686.rpm
postgresql-contrib-7.4.6-2PGDG.i686.rpm
postgresql-devel-7.4.6-2PGDG.i686.rpm
postgresql-docs-7.4.6-2PGDG.i686.rpm
postgre