Re: [SQL] Help : insert a bytea data into new table

Quoth dennis den...@teltel.com: here is example table name is mail: column| type - sender|char subject |char I presume you mean 'varchar'? content |bytea I want copy some record into new table 'mail_new'. sql: create table mail_new as

[SQL] Remote monitoring of Postgres w/minimal grants

I'm setting up remote monitoring of postgres, but running into an uncomfortable situation with permissions. Basically it seems hard to set up a secure read only role, yet also allow proper monitoring. A brief writeup of that is here: