项目作者: danilobatistaqueiroz

项目描述 :
codeigniter postgresql
高级语言: PHP
项目地址: git://github.com/danilobatistaqueiroz/quartosweb.git
创建时间: 2017-10-26T02:06:43Z
项目社区:https://github.com/danilobatistaqueiroz/quartosweb

开源协议:

下载


download postgresql for windows from: https://www.enterprisedb.com/postgresql-959-binaries-win32?ls=Crossover&type=Crossover
initialize the server: initdb C:/servers/pgsql/data
start the server: pg_ctl -D “C:/servers/pgsql/data” -l logfile start
create the database: createdb quartos
create the user: createuser —interactive -l -P -s -d quartoadm
connect to database: psql -d quartos -U postgres
you can create the user after connected: create user quartoadm WITH PASSWORD ‘123’;
grant all permissions to useradm on doctrinedb: GRANT ALL PRIVILEGES ON DATABASE quartos to quartoadm;
you can grant all privileges to useradm on all tables: GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO quartoadm;
and privileges on sequences: GRANT ALL PRIVILEGES ON ALL sequences IN SCHEMA public TO quartoadm;