PostgreSQL

After the PostgreSQL software version upgrade, you need to use Pg_upgrade to migrate the old version of the database, the specific operating parameters can refer to the official documentation, here to record the operation of the details of the

PostgreSQL Add a self-increment constraint ALTER TABLE table_name ALTER COLUMN COLUMN_NAME SET default Nextval (' Seq_name '); If you need to build a seq_name sequence, How does the trigger function of PostgreSQL debug? Self-addressed, equipped with

At a time when the database is becoming large, the base is too large and inconvenient to facilitate the management of database data, such as by time, by region to statistic some data. Many commercial databases provide the concept of partitioning,

I use the Postgres version of the source code for postgresql-9.3.5.The system is CentOS6.5, which is 64 bits.Read the README directly after downloadingThen read the install and follow the steps to do it.I was compiling, because there are two

Project team to the table structure of the document, handwriting is too cumbersome to use the SLQ script to export a copy.--Queries All table field information (with table name)Select(Select Relname| | ' --' | | (select description from

PostgreSQL function is huge, to achieve multiplication this kind of operation has many methods, today I will briefly enumerate the following several convenient ways.Like we're counting 10!1, you can use SQL to expand it:t_girl=# Select 1*2*3*4*5*6*7*

1. Check the database size:Select Pg_database_size (' log_analysis ');(Single Step mode:verify command) *******************************************select pg_database_size ( ' log_analysis ' ); return return to cancel) ********************------------

Continue to record the learning process Europe ~ ~Yesterday accidentally made Springmvc MyBatis PostgreSQL code to delete, hey ~ want to undo, results do not allowBut Sey Park is not blessed to lose his horse.Once again today, it's time to

Stored ProceduresImplementation function: For salary scale under 30 years of age, salary increase 10% 30 to 40 increase 20% 40 + 30% + bonus (admission) return average compensation To create a table: DROP TABLEEmps;CREATE TABLEEmps

Because PostgreSQL does not correctly set the allowed IP address, we often cannot connect to a database server remotely. Machine A installs PostgreSQL. The default port is 5432.To remotely connect machine B to the postgresql service of machine.1.

The previous distributed compilation and releaseProgramIt uses sbcl + clsql + MySQL and is basically normal. In this statistical back-end, the database switched to ipvs and continued to use clsql to connect. The result was a very crazy problem:  

How to query the names of all user-defined data tables in a database in PostgreSQL @ Forandever 2011-11-13 1. query through command line\ D database-- Obtain the names of all tables.\ D table name-- Get the table structure 2. query through SQL

The default maximum number of connections in PostgreSQL is 200. If the number of connections exceeds 200, so many clients alreay will be reported. Of course, you can view the current maximum number of connections through show max_connections;  

I recently tried PostgreSQL, a free database software, and encountered some obstacles. The system is windows. I. VC ++ runtime error during installation The installation version is the latest 9.2.3.1, and the Windows 7 system on the local machine is

PostgreSQL has three ways to set the primary key incrementing mode. The following describes the similarities and differences. -- Method 1Create Table test_a(Id serial,Name character varying (128 ),Constraint pk_test_a_id primary key (ID)); Notice:

Background: The PostgreSQL server runs on Redhat Linux and the IP address is 192.168.230.128. The client is installed on Windows XP with the IP address 192.168.230.1 Configuration method: 1. Modify the/opt/PostgreSQL/data/PostgreSQL. conf file on

-- View DatabaseSelect * From pg_database; -- View tablespacesSelect * From pg_tablespace; -- View LanguageSelect * From pg_language; -- View Role usersSelect * From pg_user;Select * From pg_shadow;Select * From pg_roles; -- View the session

A netstream object transmits audio and video streams between all online objects. If you only want to pass text chat content, you can use shared objects instead of using them. The basic attributes of this object are: Time until now, the number of

Note that the download is a binary version, not a Windows installer. Http://www.enterprisedb.com/products-services-training/pgbindownload Download idea from x86Before performing the following steps, make the following assumptions: PostgreSQL is to

Pg_dump backup data-- You only need to enter the name of the database to be exported after the command prompt to back up the database, as shown in the following example (change the PostgreSQL path based on your own installation path ): The code is