精品POSTGRES73和KINGBASE命令及调用参考.docx
- 文档编号:10679551
- 上传时间:2023-02-22
- 格式:DOCX
- 页数:15
- 大小:18.37KB
精品POSTGRES73和KINGBASE命令及调用参考.docx
《精品POSTGRES73和KINGBASE命令及调用参考.docx》由会员分享,可在线阅读,更多相关《精品POSTGRES73和KINGBASE命令及调用参考.docx(15页珍藏版)》请在冰豆网上搜索。
精品POSTGRES73和KINGBASE命令及调用参考
[精品]POSTGRES73和KINGBASE命令及调用参考
NCICCONFIDENTIAL
Postgres7.3和Kingbase命令及调用参考
性能评测小组
姚勇斌
2003-11-3
NCICCONFIDENTIAL
(一)Postgresql7.3参考.........................................................................................3一、Postgresql7.3命令参考....................................................................................................3
1、登陆postgres7.3主机用户名与口令.........................................................................3
2、初始化数据库(已经初始化完毕)............................................................................3
3、启动数据库.................................................................................................................3
4、停止数据库.................................................................................................................3
5、创建用户yyb(已经创建完毕)..............................................................................3
6、用户yyb创建数据库mydb(已经创建完毕).......................................................4
7、用户yyb进入数据库mydb.......................................................................................4
8、建表脚本(已经建好).............................................................................................4
9、插入数据脚本:
(已经插入)...................................................................................4
10、查询数据...................................................................................................................5
11、退出数据库...............................................................................................................5二、利用C调用数据库postgresql7.3参考...........................................................................5
1、目录和文件存放地址.................................................................................................5
2、编译.............................................................................................................................5
3、执行.............................................................................................................................5
4、执行结果.....................................................................................................................6三、利用JAVA调用数据库postgresql7.3参考....................................................................6
1、目录和文件存放地址.................................................................................................6
2、编译.............................................................................................................................6
3、执行.............................................................................................................................6
4、执行结果.....................................................................................................................7
(二)、Kingbase参考.............................................................................................8一、Kingbase命令参考...........................................................................................................8
1、登陆kingbase主机用户名与口令.............................................................................8
2、进入kingbase数据库用户名与口令.........................................................................8
3、SQL语句与表的操作(表weathercities同post)................................................8
4、退出数据库.................................................................................................................9二、利用C调用数据库Kingbase参考.................................................................................9
1、文件存放地址.............................................................................................................9
2、编译.............................................................................................................................9
3、执行及结果.................................................................................................................9三、利用JAVA调用数据库Kingbase参考...........................................................................9
1、文件存放地址.............................................................................................................9
2、编译.............................................................................................................................9
3、执行及结果...............................................................................................................10
(三)、常见问题参考(FAQ)............................................................................10一、怎样安装postgresql7.3?
................................................................................................10二、出现“连接拒绝错误”怎么办?
.................................................................................12三、出现“驱动调用错误”怎么办?
.................................................................................12四、出现“认证失败错误”怎么办?
.................................................................................12
NCICCONFIDENTIAL
经过相关测试,我们得出的结论是:
1、Kingbase采用了PostgreSQL的内核,我们以后的相关实验和编程先在PostgreSQL
上进行,然后再向KingBASE移植。
2、通过.so文件,libpq库,jdbc驱动等文件的比较,我们认为与kingbase最相似的postgresql
版本是postgresql7.3。
因此所以建议采用postgresql7.3作测试,下面介绍postgresql7.3命令和调用参考。
(一)Postgresql7.3参考
一、Postgresql7.3命令参考
1、登陆postgres7.3主机用户名与口令
首先登陆节点10.16.0.101
telnet10.16.0.101
login:
dbtest
password为空
然后登陆10.16.0.200
telnet10.16.0.200
login:
postgres73
password为空
2、初始化数据库(已经初始化完毕)
initdb-D/opt/pgsql73/data
3、启动数据库
pg_ctlstart-D/opt/pgsql73/data
4、停止数据库
pg_ctlstop-D/opt/pgsql73/data
5、创建用户yyb(已经创建完毕)
[postgres73@node200postgres73]$createuseryyb
NCICCONFIDENTIAL
Shallthenewuserbeallowedtocreatedatabases?
(y/n)yShallthenewuserbeallowedtocreatemorenewusers?
(y/n)yCREATEUSER
6、用户yyb创建数据库mydb(已经创建完毕)
[postgres73@node200postgres73]$createdb-Uyybmydb
CREATEDATABASE
7、用户yyb进入数据库mydb
[postgres73@node200postgres73]$psql-Uyybmydb
Welcometopsql7.3,thePostgreSQLinteractiveterminal.
Type:
\copyrightfordistributionterms
\hforhelpwithSQLcommands
\?
forhelponinternalslashcommands
\gorterminatewithsemicolontoexecutequery
\qtoquit
8、建表脚本(已经建好)
CREATETABLEweather(
cityvarchar(80),
temp_loint,--lowtemperature
temp_hiint,--hightemperature
prcpreal,--precipitation
datedate
);
CREATETABLEcities(
namevarchar(80),
locationpoint
);
9、插入数据脚本:
(已经插入)
INSERTINTOweatherVALUES('SanFrancisco',46,50,0.25,'1994-11-
27');
INSERTINTOweather(city,temp_lo,temp_hi,prcp,date)
VALUES('SanFrancisco',43,57,0.0,'1994-11-29');INSERTINTOweather(date,city,temp_hi,temp_lo)
VALUES('1994-11-29','Hayward',54,37);
NCICCONFIDENTIAL
INSERTINTOcitiesVALUES('SanFrancisco','(-194.0,53.0)');INSERTINTOcitiesVALUES('NewYork','(-200.0,90.0)');INSERTINTOcitiesVALUES('Washington','(-70.0,40.0)');10、查询数据
mydb=#select*fromweather;
city|temp_lo|temp_hi|prcp|date---------------+---------+---------+------+------------
SanFrancisco|46|50|0.25|1994-11-27
SanFrancisco|43|57|0|1994-11-29
Hayward|37|54||1994-11-29(3rows)
mydb=#select*fromcities;
name|location
---------------+-----------
SanFrancisco|(-194,53)
NewYork|(-200,90)
Washington|(-70,40)
(3rows)
11、退出数据库
mydb=#\q
二、利用C调用数据库postgresql7.3参考
1、目录和文件存放地址
/home/postgres73/c/testlibpq2.c
2、编译
cc-otesttestlibpq2.c-L/opt/pgsql73/lib–lpq
3、执行
./test或者./makefile
NCICCONFIDENTIAL
4、执行结果
[postgres73@node200c]$./test或者
[postgres73@node200c]$./makefileThisispostgresqldatabasedata:
tablecities----SanFrancisco----tableweather=======SanFrancisco=======
tablecities----(-194,53)----tableweather=======46=======
tablecities----NewYork----tableweather=======SanFrancisco=======
tablecities----(-200,90)----tableweather=======43=======
tablecities----Washington----tableweather=======Hayward=======
tablecities----(-70,40)----tableweather=======37=======三、利用JAVA调用数据库postgresql7.3参考1、目录和文件存放地址
/home/postgres73/java/postdb.java或者
/home/postgres73/java/DataBaseSql.java2、编译
javacpostdb.java(连接数据库测试程序)
或者
javacDataBaseSql.java(可以测试数据库连接,查询、插入、删除、修改等多种SQL执行语句,以及游标的使用、汉字转码等的程序)
3、执行
javapostdb或者
javaDataBaseSql
NCICCONFIDENTIAL
4、执行结果
[postgres73@node200java]$javapostdbNowDriverNameorg.postgresql.DriverpassedThepostgresqldatais:
ColumnreturnedSanFranciscors2=======SanFrancisco======
46500.25
ColumnreturnedSanFranciscors2=======NewYork======
43570
ColumnreturnedHaywardrs2=======Washington======
3754null
[postgres73@node200java]$javaDataBaseSqlSanFrancisco
46
50
0.25
1994-11-27
=======第1条记录结束================
SanFrancisco
43
57
0
1994-11-29
=======第2条记录结束================
Hayward
37
54
null
1994-11-29
=======第3条记录结束================
NCICCONFIDENTIAL
(二)、Kingbase参考
一、Kingbase命令参考
1、登陆kingbase主机用户名与口令
首先登陆节点10.16.0.101
telnet10.16.0.101
login:
dbtest
password为空
然后登陆10.16.0.200
telnet10.16.0.200
login:
kingbase
password:
空
2、进入kingbase数据库用户名与口令
isql-USYSTEMkingdb
password空
3、SQL语句与表的操作(表weathercities同post)
[kingbase@node200c]$isql-USYSTEMkingdb
Password:
Welcometoisql2.0,theKingBaseESinteractiveterminal.
Type:
\hforhelpwithSQLcommands
\?
forhelponinternalslashcommands
\gorterminatewithsemicolontoexecutequery
\qtoquit
kingdb=#select*fromweather@
CITY|TEMP_LO|TEMP_HI|PRCP|DATE---------------+---------+---------+------+------------
SanFrancisco|46|50|0.25|1994-11-27
SanFrancisco|43|57|0|1994-11-29
Hayward|37|54||1994-11-29(3rows)
kingdb=#select*fromcities@
NCICCONFIDENTIAL
NAME|LOCATION---------------+-----------
SanFrancisco|(-194,53)
New
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 精品 POSTGRES73 KINGBASE 命令 调用 参考