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
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 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
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?
--- 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
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
