Our company has developed a database product based on Postgres, needless to say we have changed the source code of OSS, and have also integrated and written some plugins. Therefore, when PostgreSQL and related plugins are upgraded, we also need to
1. Save Excel as a CSV2. Open CSV format with TXT3. Encoded in UTF-8 format, save as Blacklist20141231.csv4. Create a tableCreate table backlist_20141231 (date varchar (20), mobile number nvarchar (20), channel nvarchar (50));5. Using the Copy
With Windows systems, Excel is always unavoidable.The Postgres version is 9.3.6;windows 8.1 64-bit.There is no way to find Excel directly import Postgres, there is a tool is XLSTOPG, similar to SQL Server Import and Export Data Wizard, but not open
Seven, Pg_dump:
Pg_dump is a tool for backing up the PostgreSQL database. It can even make a full, consistent backup when the database is being used concurrently, without blocking access to the database by other users. The dump format generated by
0. Remove unnecessary tables and stored procedures from the 200 server Setup database
DROP TABLE "Sensorpressure";DROP FUNCTION hex_to_int (text);DROP FUNCTION "Pressuredatatosensorpressure" ();
1. Back up 200 of the SETUPD database,:p g_dump-d-H
0, password file:
Before giving other PostgreSQL client commands, we need to introduce the password file in PostgreSQL. The file is explained here in advance because we are applying the file in a lot of the following sample code to ensure that our
Recently in the membership system, where the membership system has a copy of the enterprise information initialized data, need to import from SQL Server database to PostgreSQL, single-table data of nearly 300,000.The first scenario is to generate
BackgroundPostgreSQL logical backup, refers to online backup database data, DDL output as SQL statements, data can be in the form of SQL statements or fixed separators (row format) output.
The backup does not affect the DML operation of the Backup
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.