Featured
-
No Featured Found!
Tags
Manage old database to new database in PostgreSQl (OpenERP)
In OpenERP if users manage old database to new database and delete all record in old database and use this database in new financial year so using database query in Postgresql framework to manage database. This is very helpful for new financial y...
Useful PostgreSQL Command
Some Useful PostgreSQL Command in below example->
Backup database-
pg_dump -U geekstuff erp -f mydb.sql
Restore database-
psql -U erp -d erp_devel -f mydb.sql
Change owner of database-
ALTER DATABASE erp_v1 OWNER TO openerp;
...