PostgreSQL

The introduction recently collated some of the most common commands for PostgreSQL, for reference 1 only. Common commands:# time Word Fu timestampSelectExtract (Epoch fromDate'2018-04-11 23:59:59')); #1523404800# Timestamp to time stringSelectDate

PG configuration file is the database directory of the postgresql.conf file, 8.0 later version can support k,m,g such parameters, as long as the corresponding parameters are modified to restart the PG service OK.shared_buffers: This is the most

This article installs the PostfixAdmin2.92 version of Ubuntu14.04 with PostgreSQL and Nginx.Packages that need to be installedMemory is a little vague, probably listed:POSTFIX,POSTGRESQL,POSTFIX-PGSQL,PHP5-PGSQL,NGINX,PHP5-FPM, these packages can be

1 Command line logon databaseThere are two ways to execute the psql command directly under the system shell, instead of entering the PSQL environment before connecting to the database. Examples are given below:(1) Direct loginExecute command:psql-h 1

One, to see which users are linked to the databaseSelect from Pg_stat_activity;The pg_stat_activity here is actually a view, and its definition can be found in the View section of the Postgres database.Second, kill the process now we find all the

1. Indexing methodThe PostgreSQL database supports single index, multi-column composite index, part index, unique index, expression index, implied index, and concurrent index.2. Indexing methodsPostgreSQL supports B-tree, hash, GiST, and GIN index

--Configs requiring PostgreSQL restartselect name, setting, context from pg_settings where context = ' postmaster ';postgres=# select name, setting, contextpostgres-# from pg_settings where context = ' postmaster ';name | setting | Context----------

PostgreSQL supports arrays, but does not have a function to sort the inner elements of the data. Today I wrote one with Plpgsql and Plpythonu, respectively.Sample Table structure:t_girl=# \d Test_array; Table

1. BackgroundIn the production of the overall open source toolbox products, data warehousing is an important link. Although PostGIS provides data warehousing interface operations, this tool cannot be integrated into our toolbox, and the tool

First, IntroductionPostgreSQL is currently the world's richest data type support, some data types can be said that even commercial databases are not available, such as IP type and geometry type, and secondly, PostgreSQL is a full-featured free

CentOS versionLSB Version:: Core-4.1-amd64:core-4.1-noarchDistributor Id:centosDescription:centos Linux release 7.0.1406 (Core)release:7.0.1406Codename:coreNote: CentOS installs PostgreSQL with YumThe database program path is:/usr/pgsql-9.2The

4.6 Effective cleanup and recovery endsIn recent years, recovery.conf has become more and more powerful. Early in the beginning (before PostgreSQL 9.0), there were only Restore_command and some recovery_target_time related settings. More modern

Pl/python-python Procedural Language installation Check that the system provides the Plpython package (already compiled). [[email protected] ~]# DNF search python |grep postgresqlpython3-postgresql.x86_64:connect to PostgreSQL with

Install Postgrep under Mac. Easy installation using the Brew Package management tool Brew is the Homebrew installation method Ruby-e "$ (curl-fssl https://raw.githubusercontent.com/Homebrew/install/master/install)" Mac OS x already comes with Ruby

Enter PostgreSQL1 Enter the database default installation will create Postgres users, using Postgres user, Psql command directly into the database: Bash code $ su postgres//psql user $   Psql//default direct access to $ psql-u posrgres-d dbname//Use

PostgreSQL is a famous open-source database. Recently, the PostgreSQL Global Development Team released the latest version 9.2, which greatly improved the performance and added built-in support for JSON. As early as the release of beta in March,

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-

The old version is here PHP 5.4.10 + nginx1.0.12 + PostgreSQL 9.1.3 source code compilation automated deployment Second Edition Http://blog.csdn.net/qzier_go/article/details/7316510 This time, we added the startup script. php added GD, mbstring,

Yesterday, I used the pygresql module in the article "Python: Operating PostgreSQL databases (using pygresql)" to perform operations on PostgreSQL databases, today, we use another common Python database access interface dB api2.0 to perform the same

-- Drop function top100cur (refcursor); Create Function top100cur (refcursor) returns refcursor as $ beginopen $1 for select * From person limit 100; return $1; end $ language plpgsql; ---------- test cursor ----------- select top100cur ('abc'); --