Re: [SQL] Help : insert a bytea data into new table
Quoth dennis : > 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 select * from mail sender='dennis' You omitted the WHERE. It's very hard to see what's actually going on when you keep mis-typing the commands you used. > result has an error: > operator does not exist: text || bytea > > > But if my sql statement has no column "content" > the sql works. > sql: > create table mail_new as select sender,subject from mail sender='dennis' No, it still doesn't give that error for me. Show us something you've *actually* *tried*. Ben -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[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: http://help.logicmonitor.com/installation-getting-started/notes-for-monitoring-specific-types-of-hosts/databases/postgresql/postgresql-credentials/ In order to get accurate server busy stats and max query time, the LogicMonitor user needs to be a superuser "alter role logicmonitor superuser;". Without the SuperUser privilege, all servers will appear busy, and maximum query time will always be 0. Is there a way to grant the type of permission needed to view stats, without superuser? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
