PostgreSQL

According to previous colleagues, this database is faster than oracle. I want to perform a test. The test content is very simple. The same table structure and the same amount of data are counted several times to compare to the average time. The

Installation environment: Ubuntu 64bit PostgreSQL 9.0   1. Install PostgreSQL Enter the following command Sudo apt-Get install PostgreSQL   The system prompts you to install the required disk space. Enter "Y" to installProgramWill be

When installing PostgreSQL, the following problems occur: After retrying for many times, the problem persists. In the end, the problem is solved through online search by using the following methods: the problem of database locale settings cannot be

Today is depressing. In the SHP file of National Basic Geographic Data, the provincial data adcodd99 is int type. I imported it into PostgreSQL and it became int4 type. However, the adcodd99 of the district-level data is portable and imported

Original article address: Use PostgreSQL stored procedures and views in openerp   The steps for openerp to use PostgreSQL stored procedures and attempts are as follows: Step 1: Define the stored procedure in the module's init Function DefInit

From the Internet, we can see that. NET operates on PostgreSQL. Article Http://www.zdnet.com.cn/developer/code/story/0,3800066897,39530081-1,00.htm) According to his example, it is wrong, mainly because of some details, which he did not

Problem:Org. PostgreSQL. util. psqlexception: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.Solution: Edit/var/lib/pgsql/data/PostgreSQL. conf fileChange# Listen_addresses = '

I. Overview: A database can be considered as a name set of an SQL object (database object). Generally, each database object (table, function, etc.) belongs to only one database. However, for some system tables, such as pg_database, it belongs to

I. Basic concepts: SQL functions can contain any number of queries, but the function returns only the results of the last query (which must be select. In simple cases, the first row of the last query result is returned. If no row is returned for

The method, principle, and form of postgresql client verification are similar to the *** host *** of Linux :- PostgreSQL will find the first record that matches the connection type for verification. If verification fails, verify the next or special

Detailed analysis of postgresql yesterday today and tomorrow http://database.51cto.com/art/200708/53762.htm Evaluate the advantages and disadvantages of MySQL and PostgreSQL http://database.51cto.com/art/200612/36844.htm PostgreSQL installation

PostgreSQL manages database access permissions through roles. we can regard a role as a database user or a group of database users. Roles can have database objects, such as tables and indexes, or grant permissions on these objects to other roles to

Environment: centos 6.3 minimizes the default installation and configures the NIC. Before installing PostgreSQL, check that the Internet connection is normal to download the installation file. Use the Yum-y update command to upgrade the system

Iv. PostgreSQL/PostgisInstall Some figures have not been cut down. I have already downloaded them in FreeBSD. In fact, read the installation instructions of the software, which is very simple. Log on to the http://www.postgresql.org and download the

Because it is in the development stage, the Postgres parameter is not configured, and the default configuration during installation is used,In the past, nothing was abnormal, but my CPU usage suddenly increased a few days ago.Check the process and

In MySQL, copy the existing table structure to a new table: Method 1:Create Table custnew1 like MERs MERS; In this method, only the structure of the table to be copied and the structure of the new table can be used to add new columns while

CREATE OR REPLACE FUNCTION isdigit(text) returns BOOLEAN AS 'select $1 ~ ''^(-)?[0-9]+$'' as result' LANGUAGE sql; --test functionSELECT isdigit('1') --return trueSELECT isdigit('A') --return false       CREATE OR REPLACE FUNCTION isString(

1. input parameters   NPageSize number of records per page The page number of the nPageIndex to display,> = 1 StrOrderByFieldName sorting Field StrOrderByDirection Other query Conditions   2. calculate the total number of pages   Total number of

The following describes how to install postgresql on redhat8.0. 1. Download the source code package 8.0.1  2. installation./Configure Make Su Make install Adduser postgres Mkdir/usr/local/pgsql/data Chown

PostgreSQL is the world's most advanced open-source database system. It provides multi-version parallel control and supports almost all SQL components (including subqueries, transaction and user defined types and functions), and can obtain a very