PostgreSQL

Copy Code code as follows: function Getarray_postgresql ($ARRAYSTR) { $REGX 1 = '/^{(. *)}$/'; $REGX 2 = "/\" (\\\\\\\\|\\\\\ "|[ ^\"])+)\"| [^,]+/"; $REGX 3 = '/^[^ '].*$|^ ' (. *) "$/"; $match = null; Preg_match ($regx 1, $arraystr,

Stop the Old Library There's nothing to say. Initializes a new database with a new version of 9.4 There's nothing to say. Check /usr/local/cellar/postgresql/9.4.1/bin/pg_upgrade-c--link-b/usr/local/cellar/postgresql/9.3.5/bin-b/usr/local/

Building a test table structureCREATE TABLE T_test(ID Integer,Name text COLLATE pg_catalog. " Default ",Address character varying ($) COLLATE pg_catalog. " Default);Inserting test dataInsert INTO T_test SELECT generate_series (1,10000000) as key, '

1. Create a sample tableCreate temp table settings asSelect '{"West": [{"ID":"aa92f346-7a93-4443-949b-4eab0badd983","version":1}, {"ID":"cd92e346-6b04-3456-050a-5eeb0bddd027","version":3} ]}':: jsonb as value; 2. Retain version=1 data as

1. Add a columnALTER TABLE table_name ADD column_name datatype;2. Delete a columnALTER TABLE table_name DROP column_name;3. Change the data type of a columnALTER TABLE TABLE_NAME ALTER COLUMN_NAME TYPE datatype;4. Renaming a tableALTER TABLE

When the PG installation is complete, the log is not logged by default and the corresponding (${pgdata}/postgresql.conf) configuration must be modified to only describe the common log configuration.1.logging_collector = on/off ----whether to

Inheritance is the concept of an object-oriented database. It opens the door to new and interesting possibilities for database design.Let's create two tables: a cities table and a capitals table. Naturally, the capital is also the city (cities), so

#安装python Pip (installed in the physical environment)sudo apt-get install Python-pipsudo apt-get install Python3-pipsudo pip install--upgrade pipsudo pip3 install--upgrade pip Note Description: Python-pip is the Python2 version of the package

Encounter a hole: for the following codeSelect * from where > ' 2015-11-1 ' and date'2015-11-5'Results can be obtained when executed in the client of PostgreSQL, but when executed in Java (the time range is a parameter, type string), such as Date &

Reference: https://hub.docker.com/_/postgres/https://docs.docker.com/engine/installation/debian/Using Docker for multi-instance installation is simpler, more convenient, and better isolated than the source code.Installing Docker Update the

Original address: http://blog.chinaunix.net/uid-26642180-id-3485465.htmlI've been learning PostgreSQL recently, and here are some of the common commands that I've compiled for PostgreSQL.Connect to the database, the default user and database is

Direct data between 2 databases, using Pg_dump without producing intermediate files.Native execution exports data from the local library to the remote library-h127.0.0.1-U|-h-U postgres dbnameNative execution import data from a remote database to a

6.4 Processing Monitoring ToolsThere are also several monitoring tools to make your daily life easier.One of the most popular monitoring tools is Nagios. It is widely used and also supports a variety of software components.To use Nagios to monitor

Legacy systems(1) Single database, single-table data volume (2) Single database, single-table data volume >1000w,hibernate+postgresqlInternet system(1) Master-slave database, read/write separation, Hibernate+mysql(2) Vertical horizontal segmentation

The Beego framework supports three database types (mysql,sqlite,postgresql) by default. Although the configuration of these three kinds of databases is very similar, there are different differences. Now it's time to summarize.The following is the

----------------------------------------------installation-----------------------------------------------------The installation section mainly refer to this article:Http://www.cnblogs.com/shanyou/archive/2012/08/25/2656783.html1. Visit

Database connection:dbconn.php$conn = Pg_connect ("host=localhost port=5432 dbname=myd user=postgres password=postgres");if ($conn) {Print "Has connected". "";}else{Print "Connect Failure". "";}?>insert operation:insert.phpRequire_once ' dbconn.php '

PostgreSQL Chinese Information SummaryAt present PostgreSQL Chinese information is very short, there are many netizens struggling to get started with less Chinese information, here to collect the following, convenient to have friends, reduce the

ExportParameter introductionYou can use pg_dump, followed by the database to be exported-U indicates the user-F specifies the file to import.-T specifies which table to export only-H from which server to export-- Password indicates that a password

In postresql, you only need to set the field type to serial.For example The code is as follows:Copy code Create table st_cat(Id serial not null,Parentid integer,-parent idCatname character varying (20),-category nameMemo character varying (500),-