>Now that I have a database functional, I need to allow other users
>to have access. Using createuser I can give other users access to
>the postmaster, but I need to give them access to my database as well.
>
>Could someone enlighten me.
Access to tables is controled with the Grant and Revoke S
I have a table I created and it shows up when I do the \dt from the psql prompt. But
when I try to
do a select from it I get the following.
select * from jddattdata;
ERROR: cannot find attribute 1 of relation jddattdata
I haven't inserted any data yet. I tried to drop the table and I get an
Now that I have a database functional, I need to allow other users
to have access. Using createuser I can give other users access to
the postmaster, but I need to give them access to my database as well.
Could someone enlighten me.
Glenn
I'm (1) new to postgres & (2) trying to "convert" the sample db found
in "The Practical SQL Handbook" Bowman, et al. to postgres. When
trying to create the following table I get "parser: parse error at or
near 'null'"
create table authors (
au_id char(11)not null,
