over 9 years ago
If you want to merging data from older database to new database in PostgreSQL or want to merge data from other database(db1) to another database(db2), follow these below steps:
copytext
copy (select * from table_name) to E'C:\\Users\\dinesh\\Documents\\table_name.csv' csv Header;
COPY table_name FROM E'C:\\Users\\dinesh\\Documents\\table_name.csv' WITH Delimiter ',' Null '' csv;
Can you help out the community by solving one of the following SQL problems?
Problems in writing sql queries anyone who can writ...
Is It Possible to Put all Upcoming to Mobirise eMai...
How to Use Calculation of an Aggregate Function as ...
Do activity (Answer, Blog) > Earn Rep Points > Improve Rank > Get more opportunities to work and get paid!
For more topics, questions and answers, please visit the Tech Q&A page.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Sign up using
0 Comment(s)