wwbutton
- 浏览: 42806 次
- 性别:
- 来自: 北京
-
最新评论
-
weiruan85：
oracle 不是有闪回特性吗，不需要这么麻烦吧
oracle Restore of delete data
文章列表
# vi /usr/localpgsql/bin/pg_bakjedi.sh
#!/bin/sh
nowtime=`/bin/date +%Y%m%d%H`
#echo $nowtime
/usr/local/pgsql/bin/pg_dump -U postgres -CD jedidb > /usr/local/pgsql/bak/jedidb$nowtime.bak
# chmod a+x /usr/localpgsql/bin/pg_bakjedi.sh
# export EDITOR=vi
# crontab -e
10 01 * * * /usr/local/pgsq ...
- 2008-08-07 10:18
- 浏览 1112
- 评论(0)
当前时间的后两天
select CURRENT_TIMESTAMP + 2;
前一周的周五
select CURRENT_DATE - Cast(EXTRACT(DOW FROM CURRENT_TIMESTAMP) as int2) -2;
- 2008-08-07 10:16
- 浏览 1140
- 评论(0)
su - postgres
cd bin
--drop database
./dropdb -U postgres Jedi_SafeNet
--create database
./createdb -E UTF-8 -U postgres Jedi_SafeNet
--excute database script
./psql -d Jedi_SafeNet -f Jedi_SafeNet_DB.TXT -U postgres
Informational
\d [NAME] describe table, index, sequence, or view
\d{t|i|s ...
- 2008-08-07 10:14
- 浏览 1560
- 评论(0)
1. solaris version?
uname -a
SunOS test 5.10 Generic sun4u sparc SUNW,Ultra-60 –5.10 is Solaris10
cat /etc/release
Solaris 10 3/05 s10_74L2a SPARC
2. CPU Info ?
psrinfo -vp
The physical processor has 1 virtual processor (0)
UltraSPARC-II (portid 0 impl 0x11 ver 0xa0 clock 450 MHz)
The physical proces ...
- 2008-08-07 10:13
- 浏览 1037
- 评论(0)
SQL CASE 表达式是一种通用的条件表达式，类似于其它语言中的 if/else 语句。
<big>CASE WHEN condition THEN result
[WHEN ...]
[ELSE result]
END</big>
<big>
select COALESCE(nullif(0, 0), 1) --return 1
select nullif(1,2) --return 1
select nullif(1,1) --return null
select ...
- 2008-08-07 10:11
- 浏览 2006
- 评论(0)
INIT: Cannot create /var/adm/utmp or /var/adm/utmpx
===================================================
This console message indicates that init(1M) cannot write in the
/var directory, which is usually part of the / (root) filesystem.
Some other messages follow, andthe system usually comes up
single ...
- 2008-08-07 10:04
- 浏览 1191
- 评论(0)
./pg_restore -i -U postgres -d Jedi_Storage -c Jedi_Storage.backup
-a
--data-only
只恢复数据，而不恢复表模式（数据定义）。
-c
--clean
创建数据库对象前先清理（删除）它们。
-C
--create
在恢复数据库之前先创建它。（如果出现了这个选项，和 -d ...
- 2008-08-07 10:02
- 浏览 2690
- 评论(0)
FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
A small (single-precision) floating-point number. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38. These are the theoretical limits, based on the IEEE standard. The actual range might be slightly smaller dependi ...
- 2008-08-07 09:53
- 浏览 4318
- 评论(0)