我现在正开始接触postgresql,但我是把它装在WindowsXP下。最近,别人提供了一份数据库文件,我想通过这个数据库文件对我的数据库进行恢复,所以我就用PgAdmin3打开数据酷,右键默认的已经创建好的数据库postgres,选择restore, 可每次备份都不成功,具体情况如附件中所示,我在网上把数据库文件传给别人试,他们也会出错,但最终他们的数据库中会有数据,我却什么都没有,请问这到底是怎么回事,能帮我分析分析吗?谢谢,期待您的回...
by 阿鹏monsieur - PostgreSQL - 2008-04-21 11:34:07 阅读(3431) 回复(1)
Hi, Does any one successfully connect Erwin 4 with postgres ?
I configured ODBC on windows and ODBC test is okay. But I can not let Erwin use this ODBC to connect postgres.
各位兄台,装完数据库,输入psql出现如下提示,这个该怎么解决?
[postgres@text]$ psql
-bash: psql: command not found
[postgres@text]$
本帖最后由 zhuyongxin 于 2010-04-07 22:59 编辑
有一表结构如下:
day equipment output
2010/4/1 DAT501 100
2010/4/1 DAT502 120
2010/4/2 DAT501 110
2010/4/2 DAT502 105
查询结果:
day DAT501 DAT502
2010/4/1 100 120
2010/4/2 110 105
这个查询怎么实现?
环境:
server:fedora 9
client: windows xp
database:
BINDIR = /usr/local/pgsql/bin
DOCDIR = /usr/local/pgsql/doc
INCLUDEDIR = /usr/local/pgsql/include
PKGINCLUDEDIR = /usr/local/pgsql/include
INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
LOCALEDIR =
MANDIR = /usr/local/pgsql/man
SHAREDIR = /usr/local/pgsql/share
SYSCONFDIR = /...
[quote]
opus=# select 'http:\\207'::bytea;
bytea
-----------
http:\207
(1 row)
opus=# select 'http:\\208'::bytea;
ERROR: invalid input syntax for type bytea
opus=# select 'http:\\209'::bytea;
ERROR: invalid input syntax for type bytea
opus=# select 'http:\\210'::bytea;
bytea
-----------
http:\210
(1 row)
[/quote]
通过编码再解码解决了遇到的问题,但是谁能解释下这个