Insert data into database

Squiz Matrix Support
1

Hi folks


I try to insert some data into my own table in the matrix database.



I write the code into function printBody(), I can read and search data from this table, however, when I try to insert data into this table, the screen shows:



pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation customer_table





did anyone know how can I fix this problem, plz?





thanx

2

Hi,


You'll have to grant permission to the db user to read that table (and any others you want to access):



http://www.postgresql.org/docs/current/static/sql-grant.html


[quote]

Hi folks



I try to insert some data into my own table in the matrix database.



I write the code into function printBody(), I can read and search data from this table, however, when I try to insert data into this table, the screen shows:



pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation customer_table





did anyone know how can I fix this problem, plz?





thanx

[/quote]

3

Thanks for help, it is works now.
cheers :smiley: