Greetings,
I am new to PostgreSQL and come from an DB2
background. I currently have v8.0.3 up and running.
So far, it looks great!
One area I am confused about is how to set up
databases and users. I can currently create
databases, but I am having difficulty in assigning
mutiple users to those
--- Eric E <[EMAIL PROTECTED]> wrote:
> At the database level, you can assign creation and
> other permissions to
> users, but (AFAIK) you cannot deny users to a
> database. However, you can
> effectively control users' access to a particular
> database by granting
> or denying them access to a
I see that one can add a new column to an existing
table. The documentation was not clear on how
efficient this operation would be.
Does PostgreSQL make a copy of the entire table when
adding a new column? Or does it simply use extra
space in the data blocks to add the new column?
Hello,
I found something interesting when I try to load a
text file into a
table. I am on Windows XP and I am using the Copy
command.
If the file is under C:\Documents And Settings or
anywhere under that
folder, the database complains that it has no access
permissions. (The
file is on my deskt
Thanks, Mike! Your solution seems to have solved it.
--- mike <[EMAIL PROTECTED]> wrote:
> XP is denying access to your desktop to the postgres
> account which the
> database service is running on. If you go to the
> folder C:\Document and
> Settings\your_login_id, right click on it, select
>
Hello,I am hoping this is the right place.I have recently switched to Kubuntu and I just installed Postgres on it. The installation was successful.When I try psql, I get this error message, though:% psql postgresError: You must install at least one postgresql-client- package.But I have installed p
