Re: Create table command fails with permission denied

[AmitKumar Jain <amitjain@xxxxxxxxxxxxx>]

Title: Regards,

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

--

Regards,

 

Amit Jain
Synechron Technology Pvt. Ltd.

Pune 411 057.
Phone : +91.20.40262000 Ext 2162 | Mobile:+91.9373415075 | Fax: +91.20.30513500
http://www.synechron.com | MailTo: amitjain@xxxxxxxxxxxxx