Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
How To Install and Use PostgreSQL on Ubuntu 14.04 ?
About PostgreSQL
PostgreSQL is a relational database management system. It is having advanced features so it is used in many small and large projects.
I am writing this blog which will let you know how to install Postgres on an Ubuntu 14.04...
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...
How to resolve Registry issue in Postgres
If on installing OpenERP 6.1 using all-in-one setup, pgAdmin is note getting installed or you are not
able to select pgadmin while installation then you might be having a registy issue with postgres
application. To solve this king of problem....
How to setup a postgreSQL in OpenERP
The default superuser for PostgreSQL is called postgres. You may need to login as this user first.
Than use this commond in terminal
openerp@ubuntu:/$ sudo su postgres
password: XXXXXXXXXX
Now create PostgreSQL user openerp using the fo...
Frequently used commands in Postgres database with psql command line tool
Connect to local server using psql command line tool with postgres user.
sudo -u postgres psql postgres
To set/change password of postgres user
\password
To check/list all databases
\list or \l
To see/list all tables in current...
Renaming a database in PostgreSQL
For renaming a database in pgAdmin:
Go to pgadmin and select 'postgres' database and click on the query tool; run the query:
ALTER DATABASE old_dbname RENAME TO new_dbname
Example:
ALTER DATABASE test_ky RENAME TO kwality(14-15)
Password Recovery in OpenERP
Can't log in? Forgot Password? Many users and many passwords?
All these questions are very common in daily operations of your OpenERP. If you are admin then you have all the access to change or recover passwords for other users as well.
Thi...
Database creation using PostgreSQL
Database creation using PostgreSQL
To start work with postgres, you need to install Postgres. To download PostgreSQL 9.1, go through below link:
Download
To check that you are able to access psql, open cmd and fire command psql.
If you ...
Avoiding gap in ids for a table in OpenERP PostgreSQL
Sometimes when we delete few or all records from a table, we may want ids of records to be in sync with the last record or the first one, but what we get is that new ids with a significant amount of gap have been generated, for example if it shou...
Access PostgreSQL using IP address
To add a new server connection using an IP address, you need to follow these steps:
Go to the folder PostgreSQL/data, and edit the file postgresql.conf, add the following line at the end of the file and save:
listen_addresses = '*' ...
How to import/export data using CSV in PostgreSQL
To export a table data from Postgres database to a CSV file, use the "COPY to" command. You can create a CSV file using MS-Excel or directly create a file from the command.
Syntax: COPY (SELECT * FROM table_name) to E'C:\Users\main\Documents\...