Re: Create table command fails with permission denied - Mailing list pgsql-admin

Venkateswara Rao Bondada wrote:

Hi,

I’m new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 database. I’m getting the following error when tried to create a table. Please let me know the steps (with queries) that I should take care to resolve this issue.

 

cms=# create table test(id character varying(80));

ERROR:  could not create relation "test": Permission denied

 

Thanks in advance,

Venkat

login with postgres user like psql -Upostgres cms   and THEN execute create table statement.

OR
    Refer this  : http://www.postgresql.org/docs/7.4/static/sql-grant.html