On 03/14/12 12:38 AM, Alexander Reichstadt wrote:
this was probably asked dozens of times before, but I couldn't find where, and neither in the docs and what I found on the web didn't make sense. I found how to create users and check their permissions using terminal. But I need to alter and create users and permissions through libpq or SQL directly. I also found there to be a reference on the INFORMATION_SCHEMA, but still couldn't make sense out of these tables in the given context. This is to make a user administration inside the client frontend. What approach would be recommended for this purpose?
SQL commands like...
CREATE USER freddy WITH PASSWORD 'something';
CREATe DATABASE freddb OWNER freddy;
issued same as any other SQL queries, via libpq etc.
note, the INFORMATION_SCHEMA is read only as its all implemented as
VIEW's...
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
