1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
#!/bin/sh
# memopanel.psql.sh for memopanel
# Toshiaki Kanosue 2000/05/26 Fri 16:30:44
########### Parameters #############
# psql test "\h select"
# option -x
# postmast
# rpm-postgresql
####################################
TMP=/tmp/memopanel.psql.html
DUM1=/tmp/dum1.$$
#
if [ "$1" = "h_psql" ]; then
echo "psql COMMAND = $3" > $TMP
psql $2 -H -T "border=\"8\" bordercolor=\"red\" bgcolor='cyan'" -q -c "$3" >> $TMP 2>&1
elif [ "$1" = "psql" ]; then
echo "psql COMMAND = $3" > $TMP
psql $2 -q -c "$3" >> $TMP 2>&1
elif [ "$1" = "option" ]; then
echo "psql OPTION = $2" > $TMP
psql -q $2 >> $TMP 2>&1
elif [ "$1" = "postmast" ]; then
echo "COMMAND = ps ax|grep \"post\master\"" > $TMP
ps ax|grep "post\master" >> $TMP
elif [ "$1" = "rpm-postgresql" ]; then
echo "COMMAND = rpm -aq|grep postgresql" > $TMP
rpm -aq|grep postgresql >> $TMP
elif [ "$1" = "database" ]; then
psql -l -t -q|awk 'BEGIN{FS="|"}{print $1}' > /tmp/memopanel.db
exit
elif [ "$1" = "pgcmd" ]; then
cat > $DUM1 <<@
{
if(substr(\$0,1,2)==" ") {
s1=deblank1(substr(\$0,5,24))
s2=deblank1(substr(\$0,30,24))
s3=deblank1(substr(\$0,55))
if(length(s1)) print s1
if(length(s2)) print s2
if(length(s3)) print s3;
}
}
function deblank1(str,i) {
for(i=length(str);i>0;i--) if(substr(str,i,1) != " ") { return substr(str,1,i) }
return "";
}
@
psql $2 -q -c '\h'|awk -f $DUM1 > /tmp/memopanel.pgcmd
rm -f $DUM1
exit
fi
if [ "$1" = "h_psql" ]; then
netscape $TMP
else
vim $TMP
# less $TMP
# vi $TMP
fi
rm -f $TMP
#
|
