Often add partitioned tables, and clean up partitioned tables, very simple 2 functions--Add partition table CREATE OR REPLACE function create_table (table_name character Varying,table_num integer ) RETURNS void LANGUAGE Plpgsql as $function $
Definition of a table:
For any relational database, tables are the most core and basic object unit of data storage. Now let's start from here.1. Create a table:
Copy Code code as follows:
CREATE TABLE Products (
Product_no Integer,
It provides multiple versions of parallel control, supports almost all SQL artifacts (including subqueries, transactions, and user-defined types and functions), and can achieve very broad (development) language bindings (including
In this article, we use the MySQL 4.0.2-alpha and PostgreSQL 7.2 to compare, because MySQL 4.0.2-alpha started to support the concept of transactions, so this comparison for MySQL should be more advantageous. We don't want to be just a performance
Since MySQL was acquired by Oracle, PostgreSQL has become the first choice for open-source relational databases.This article describes the installation and basic usage of PostgreSQL for first-time users to get started. The following is based on the
/* In the process of writing the Greenplum function, the following two functions are found, based on the affinity of Greenplum and PostgreSQL, when determining whether a string is a numeric or date format. */--1. Determine if a string is a digital
PostgreSQL provides a copy command for the mutual copy between the table and the file (and standard output, standard input), copy to the table to the file, and copy from the file to the table.Example 1. Copy the entire table to standard outputTest=
PostgreSQL implements table inheritance, a feature that is an effective tool for database designers. The SQL99 and later standards define the type inheritance characteristics, which are different from the many features we describe here.Let's start
What is BarmanBarman (Backup and Recovery Manager) is a convenient backup and recovery tool in the PostgreSQL database server that allows remote backup of multiple servers, allowing a single command from a single backup set to restore the database.
One, install and configure, and set the remote login user name and password1. Installing PostgreSQLsudo apt-get updatesudo apt-get install postgresql-9.4
After installing PostgreSQL under Ubuntu, it is automatically registered as a service
Environment: Win7 SP1pg:9.3.5 1, create user postgres, password is also postgres: NET user Postgres Postgres/add2. Set up the data directory under the database root directory:C:\Program FILES\POSTGRESQL\9.3>MD Data3. Remove administrator permissions
PostgreSQL Performance Monitoring ToolsHttps://github.com/CloudServer/postgresql-perf-toolsThis package includes three useful scripts aimed to help to pinpoint performance issues on systems with PostgreSQL as data Base backend.All Scritps is written
Look at the official documents of POSTGRESQL9, the more I look confused, this table space, database, mode, table, user, role relationship between how in PostgreSQL so chaotic?After a small experiment at noon, I gradually cleared up the ins and outs.
PostgreSQL code Analysis, query optimization section.Here the parts of the canonical predicate expression are sorted out, and the order of reading is as follows:One, PostgreSQL code Analysis, query optimization section, canonicalize_qualTwo,
Original: http://blog.csdn.net/kanon_lgt/article/details/5931522Look at the official documents of POSTGRESQL9, the more I look confused, this table space, database, mode, table, user, role relationship between how in PostgreSQL so chaotic?After a
4.3 Slave to master switchIf you want to extend the read or you want to make a backup of the data, a slave is a good thing. However, slave may not always be slave. At some point, you may need to convert slave to master. PostgreSQL provides some
After performing your first instant recovery (pitr,point-in-time-recovery), we are ready to work on a real replication setup. In this chapter, you will learn how to set up asynchronous replication and flow. Our goal is to ensure that you can achieve
This article is from my translation on infoq Chinese siteArticle, Original address is: http://www.infoq.com/cn/news/2012/05/vfabric51
VMware announced VMware vfabric suite 5.1, which has increased its automatic deployment and enterprise-level open-
I have to say that at this point, PostgreSQL is very powerful and no less powerful than any large commercial database. It is not that complicated to add custom functions.
The following example adds the following functions: Test (), concat_text
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service