PostgreSQL

At that time encountered this problem, a variety of Baidu also found no solution. Now that we've solved it, let's share the method: Table format must be CSV format 650) this.width=650; "title=" Eeeee.png "src=" http://s3.51cto.com/wyfs02/M01

1. Bki Introduction: http://www.postgresql.org/docs/9.4/static/bki.htmlCan not understand, nor affect us to continue, because there are many examples of ready-made reference;2. Add a field datdummy for Pg_database to

In Thursday to do database migration, the number of PG library data to be moved is 1165GB.Run the script in the background to the new library, pilot the 850M base table, and then use the script to guide the history table:-h0.0.0.0-U-t‘his*‘ |-h135.3

First, IntroductionThe purpose of a tablespace is to allow a database administrator to define a location where other non-data directories store database objects. One of the usage scenarios is that if the machine is newly added SSD, but not enough

Original link: http://blog.chinaunix.net/uid-20726500-id-4040024.htmlThe implementation principle of a transaction can be interpreted as what technology the DBMS takes to ensure the acid characteristics of the transaction. PostgreSQL's

(1) Docker DockerfileFrom centos:centos6 #使用的镜像名及其标记Maintainer CXM [email protected]>#建立此镜像的用户信息RUN yum-y update; Yum Clean All #运行的命令RUN yum-y install sudo epel-release;#Sudo requires a TTY. Fix that.RUN sed-i ' s/.*requiretty$/#Defaults

In PostgreSQL we tend to use select stored procedures in executing stored procedures, but if the stored procedure is called again, it cannot be used, and the perform stored procedure should be used to see the description of the official

Method 1-System commandssudo su-postgres #切换到postgres用户 (System user)Createdb Weichen #创建数据库Psql #直接访问数据库 (default into local postgres database)\l--View Database list: Q--Exit list page\q--Exit the clientdropdb Weichen #删除数据库Method 2-psql Command

1. Command line logon DatabasePsql-u username-d dbname-h hostip-p Port2. List all databases3. Switching the database\c dbname4. List all tables in the current database5. View all fields of the specified table\d TableName6. View the basic situation

1. TriggerRecord a log when an update is in actionDROP FUNCTION IFEXIST log_test (); CREATE OR REPLACE FUNCTIONLog_test ()RETURNS Trigger as $$ DECLARE BEGINRAISE NOTICE'TRIGGER LOG TEST'; RETURN NULL; END; $$ LANGUAGE Plpgsql; CREATE

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

Directory:1. Configure the Access databaseIn the settings.py file, add:DATABASES = {' Default ': {# ' ENGINE ': ' Django.db.backends.sqlite3 ',# ' NAME ': Os.path.join (Base_dir, ' db.sqlite3 '),' ENGINE ': ' Django.db.backends.postgresql_psycopg2 ',

Golang custom data type querying and inserting the point data in PostgreSQLThe specific code is as follows: PackageMainImport("bytes" "Database/sql" "Database/sql/driver" "FMT"_"GITHUB.COM/LIB/PQ" "StrConv" "Strings")//Custom Support

1 stored procedures that return result sets--Drop FUNCTION getall ();CREATE or REPLACE FUNCTION getall ()RETURNS Setof users as$BODY $SELECT * from users;$BODY $Language SQL; --The SQL used here2 stored procedures that return a single value--Drop

Step One: Install PG basic software NOTE: Before installing PG, it is recommended to create a Postgres account and then use this account to install the PG software. 1:./configure–prefix= ... (Point to the directory you want to install) 2:make & sudo

Installation Environment:Ubuntu 64bitPostgreSQL 9.01. Installing PostgreSQLEnter the following commandsudo apt-get install PostgreSQLYou will be prompted to install the required disk space, enter "Y" and the Setup program will complete automatically.

PostgreSQL prepares new library from library failure1, create user[Email protected] home]# Userdel Postgres[Email protected] home]# Groupdel PostgresMkdir/home/mydbChown-r Postgres:postgres/home/mydb2. Unpack the installation package[Email protected]

A database contains one or more schemas, and the schema contains tables, sequences, functions, and so on, and different schemas can contain tables, sequences, functions, and so on with the same name. A pattern is essentially a namespace, just like a

PostgreSQL by default, remote Access does not succeed, and if you need to allow remote access, you need to modify two configuration files, as described below:1.postgresql.confSet the Listen_addresses key value in the file to "*", which is already "*"

MySQL's 2 commonly used functions Unix_timestamp () and From_unixtime PostgreSQL are not available, but with PostgreSQL's powerful extensibility It is easy to solve problems.Words far away, in front of the eyes, the document look carefully, the