PostgreSQL

Environment:Django==1.9.13psycopg2==2.7.5python 3.6.5postgresql 1.18.1There was a problem configuring DjangoCheck setting, problem: The connection is unsuccessful because the user Postgres in the installed PostgreSQL does not have a default

PostgreSQL performance does not lose MySQL, and support many advanced features, so I wrote this project, according to LIBPG C drive, encapsulated the Nodejs driver.Project Address:git clone https://code.csdn.net/limite_god/pgsql.gitDevelopment

2013-05-06 08:39:20  | Category: pgsql Develop| report | Font Size Subscribe PostgreSQL 9.3 Introduces a formatted output function that is somewhat similar to the sprintf usage of C. The syntax is as follows: Format (formatstr text [, Formatarg "

The last one months when using PostgreSQL, often encountered ltree data, feel a bit awkward, but there is no way around. Today is determined to tidy up, later use more convenient.First, IntroductionLtree is an extended type of PostgreSQL, developed

The Drop Command (Commands) implements:/* * Drop one or more objects. * * We don ' t currently handle all object types here. Relations, for example, * require special handling, because (for example) indexes has additional * locking requirements. *

PostgreSQL see which references to the current table are referenced as reference tables--pg_constraint.contype:p (primary key), F (foreign key), U (unique), C (check)--View the current table IDSELECT OID, relname from pg_class WHERE relname = '

PostgreSQL has a very useful function, partition table, or partitioning. When a table has a lot of records, or even more, we actually need to divide him into sub-tables. A huge table, like a fruit warehouse littered with countless apples and peaches

1, first look at the PostgreSQL port, the default is automatically open, Port 7337.[Email protected]:~# netstat-tnpl |grep PostgresTCP 0 0 127.0.0.1:7337 0.0.0.0:* LISTEN 1100/postgresTCP6 0 0:: 1:7337:::* LISTEN 1100/postgres2. View the MSF

Create a tableSyntax: as followsCREATE TABLE table_name (column_name column_type (parametes) options,...);Attention:⑴sql statement is not case sensitive⑵ usually ignores whitespace-whitespace should be used to make SQL commands more readable.⑶ table

Recently began to do the work of C # dotnet, because of the interest in PostgreSQL database, so I studied how to access the database of PostgreSQL problem. 1. In order to access the PostgreSQL database, you need to download the npgsql. Net Data

has not paid attention to this function, yesterday looked at a bit, the database inserted bottlenecks, today studied a bit:The main scenarios are as follows:1. import from a file using copy :Copy table_001 (A, B, "F", D, C, "E") from ' D:/data1.txt '

Installation:Sudo apt-Get install PostgreSQL set the password Sudo-u Postgres Psql Postgres = # alter User Login s with password 'login s '; postgres = # \ qsudo passwd-D unzip ssudo-u Postgres passwd change configuration file sudo

What is ramdisk? How can we use it to improve the response speed of the database server? Ramdisk is usedHard DiskSpaceMemory. No matter when you use ramdisk, you actually use the memory instead of the hard disk. There are both advantages and

1. Start and close server processes: The following describes the usage and common options of the pg_ctl command. It must be noted that this command is the encapsulation body of the S command, which is more convenient to use than using Postgres

Nulls first/last The nulls first/last function is mainly used in order by sorting clauses, which affects the position of null values in the sorting result. Simply put, nulls first indicates that the null value is always in front of all values during

We are all familiar with MySQL, and PostgreSQL is not so famous. in fact, they are two similar relational databases. postgreSQL was originally named Postgres. After some improvements, it was renamed PostgreSQL. for details, visit the official

Introduction:This note describes ways to implement high availibility (HA) for PostgreSQL. HA gives the ability to transparently fail-over database connections to an alternative system in the event of some sort of failure of the primary

Create the same test table and data in MySQL (5.5.8) and PostgreSQL (9.0:Create Table test_gbk_char ( Id int, Username varchar (64) ); Insert into test_gbk_char values (1, 'qingxia '), (2, 'Man Yu'), (3, 'chu hong ');   After completing the

It turns out that the author has been using nbearlite in MSSQL, but recently I want to use it in MySQL and found a bug, mainly caused by the parameterization process. We all know that in the MSSQL database, all parameters are represented by @ ID,

Installation environment: Ubuntu 8.10 1. Enter the following command   $ Sudo apt-get install postgresql   Will prompt you whether to install the latest PostgreSQL database, enter Y, the system will automatically complete the installation   In this