New News Entry

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?167

Submitted by: netkiller(at)9812(dot)net
Headline: PostgreSQL
Summary:

PostgreSQL
(netkiller)
http://home.9812.net/linux/article/postgres/

Story:

PostgreSQL
(netkiller)

http://home.9812.net/linux/article/postgres/

1 ... 7
1.1 ... 7
1.2 PostgreSQLSQL99... 7
2 PostgreSQL ... 8
2.1 PostgreSQL... 8
2.2 RPM... 9
2.3 ... 14
2.3.1 ... 14
2.3.2 ... 15
2.4 ... 15
2.4.1 ... 15
2.4.2 ... 16
2.5 ... 16
2.6 ... 16
2.6.1 ... 16
2.6.2 ... 18
2.6.3 vacuumdb. 24
2.6.4 ... 24
2.6.5 ... 25
2.7 SSLTCP/IP... 26
2.7.1 ... 26
2.7.2 ... 29
2.7.3 ... 30
2.7.4 ... 32
2.7.5 postgresql.conf... 32
2.7.6 SSL. 38
2.7.7 pg_hba.confSSL... 38
2.7.8 ... 39
2.7.9 ... 40
2.8 SSHTCP/IP... 41
2.8.1 1. 42
3 DDL... 43
3.1 ... 43
3.1.1 ... 43
3.1.2 ... 43
3.1.3 ... 43
3.1.4 ... 44
3.2 ... 44
3.3 ... 46
3.3.1 text to varchar 46
3.4 ... 49
3.4.1 ... 49
3.4.2 123456789. 50
3.4.3 13579. 50
3.4.4 246810. 52
3.4.5 n1+n2 53
3.5 ... 53
3.6 ... 53
3.7 ... 54
3.8 ... 54
3.8.1 ... 54
3.8.2 ... 55
3.8.3 ... 56
3.9 /... 59
3.9.1 ... 59
3.9.2 ... 59
3.9.3 PostgreSQL 7.3.x ... 60
3.9.4 -... 60
3.9.5 ... 68
3.10 ... 68
3.10.1 ... 68
3.10.2 ... 68
3.10.3 ... 69
4 Entity-Relation... 71
4.1 E-REntity-Relation... 71
4.2 ... 72
4.3 ... 74
4.4 ... 76
4.5 ... 77
5 ... 78
5.1 VIEW... 78
5.2 HTMLVIEW... 79
5.3 view... 82
6 SQLDML... 84
6.1 ... 84
6.2 substring()... 86
7 ... 88
7.1 ... 88
7.2 Select Into. 89
7.3 integer 91
7.4 void. 91
8 ... 92
8.1 ... 92
9 ... 95
9.1 ... 95
9.2 ... 95
9.3 ... 98
9.3.1 ... 99
9.3.2 ... 99
10 ... 100
10.1 ... 101
10.2 ... 102
11 ... 103
11.1 ... 103
11.1.1 -1. 103
11.2 -2. 104
12 ... 104
12.1.1 ... 105
12.1.1.1 ... 105
12.1.1.2 ... 105
12.1.2 ... 106
12.1.2.1 ... 106
12.1.2.2 ... 107
12.1.2.3 ... 107
12.1.3 ... 107
12.1.4 ... 108
12.1.4.1 ... 108
12.1.4.2 IP... 109
12.1.5 ... 109
12.1.6 ... 109
13 FAQ.. 110
13.1 Postgresqlmysql 110
13.2 Putty... 111
13.3 ... 115
13.4 PostgreSQL RPM 5432... 115
13.5 PHP PostgreSQL. 118
13.6 ... 118
13.6.1 Jsp/Java. 118
13.6.2 toChinese() ... 118
13.6.3 Unicode (UTF-8) ... 118
13.6.3.1 setCharacterEncoding() ... 119
13.6.3.2 Web.xml Filter... 121
13.6.3.3 Jdbc url charSet... 127
13.6.4 PHP. 127
13.6.4.1 set CLIENT_ENCODING TO \'GB18030\';... 127
13.6.4.2 convert()... 136
13.6.4.3 PHP iconv() ... 136
13.6.4.4 I/O Linux iconv ... 138
13.7 Macromedia Dreamweaver MX 2004 JSP... 142
13.8 JBuilder + Weblogic + PostgreSQL... 152
14 ... 183
14.1 ... 183
14.2 ... 191
14.3 Case Studio 2. 214
14.4 ... 222
14.4.1 setenv.sh. 222
14.4.2 install.sh. 222
14.5 ... 226
14.6 PostgreSQL ... 226
15 ... 227
16 ... 227
17 ... 228