pgsql example

Backup and restore are most important when you are transporting a database. Today, we tested backup and restore using Pg_dumpall. Backup Restore method: Pg_dump and Pg_restore, first carefully explain these two commands Back up the database,

Recently in the study of PostgreSQL, so also has a strong interest in pl/pgsql, so here is a little summary, first of all, this PL is procedure language shorthand, that is, the so-called "process language." A large part of the following is quoted

Pgsql synchronization mode is based on the master log to do synchronization, there are two ways to synchronize, referenceHttp://www.chinaxing.org/articles/Postgres/2012/12/14/2012-12-14-hight-availability-in-postgresql.htmlPgsql logs have an

Data processing notes on JSON and JSONB for Pgsql1. JSON and JSONB differencesThere is no difference from the point of view of user operation, the difference is mainly the system processing (preprocessing) and time-consuming differences between

Today, I learned how to use PL/pgsql to write the PostgreSQL storage process. There is really little information on the Internet. The only thing I can find is to copy it. I 'd like to copy the PostgreSQL documentation, let's talk about the problem

Really did not think, has been the user of PostgreSQL, suddenly need a library transplant has become the first trick! Originally it was quite different from the MySQL command line operation.Don't be afraid, but be careful, because database operation

Pgsql Syntax to_number (text, text) Example: Select to_number (TRIM (both 'ibs 'from classname), '000000') as CN from BBS order by CN/* trim (both 'ibs' from classname) remove the 'ibs 'character in the classname field */ MySQL Syntax Str *

A sample that can jump directly to the last face to view Really did not think, has been the user of PostgreSQL, suddenly need a library transplant has become the first trick! Originally it was quite different from the MySQL command line

Mac computer built-in PHP, but the pgsql extension is not installed. For beginners, this is undoubtedly a big challenge, because Baidu Google above although there are many tutorials, but always in a few key steps error. And many of the key points

CentOS Installation PgsqlYum installs PostgreSQL under CentOSDirectory1 Configure YUM Repository2 Install pgdg RPM file3 Install PostgreSQL4 configuration5 Initialize6 StartupSpecific steps:1.Vim/etc/yum.repos.d/centos-base.repo[Base] and [Updates]