Tuesday, March 23, 2010

php and postgresql

rhelic: gavino: I'm the only person here (that I know of) that uses pgSQL, I'll tell you now, only use the pg_query_params() function, not pg_query()


php.net/pdo

http://us2.php.net/manual/en/ref.pdo-pgsql.php


'./configure' '--with-libxml-dir=/usr/pkg' '--with-pdo-pgsql=/usr/local/pgsql'

CREATE DATABASE dbname WITH OWNER ownername;
http://www.postgresql.org/docs/current/static/client-authentication.html
(14:11:12) pg_docbot_adz: http://www.ibm.com/developerworks/opensource/library/os-postgresecurity/index.html
ALTER USER username WITH PASSWORD 'newpass';

http://www.postgresql.org/docs/current/static/database-roles.html

http://www.postgresql.org/docs/current/static/manage-ag-createdb.html
(16:04:22) pg_docbot_adz: http://www.postgresql.org/docs/current/static/sql-createdatabase.html
(16:07:01) pg_docbot_adz: For information about 'create role' see:
(16:07:01) pg_docbot_adz: http://www.postgresql.org/docs/current/static/sql-createrole.html

create role -name- login password 'passwd';

No comments: