[Solved] Slight variation from the desired results
Hello,
I am writing a small one liner script to display the tables in my database.
I am working with Centos 5.5 and postgresql
the command is
"
Code:
psql -c "\dt" | awk '{print$3}'
"
I just want the 3rd column from the result set, but now the problem is I am getting the third column but with the header of \dt information.
i.e. The results I am getting is
Code:
Relation
names
actor
employee
staff
film
film-category
payment
Instead of this result, I want some thing like this.
Code:
actor
employee
staff
film
film-category
payment
The first two lines should be eliminated.
I tried using the grep -A command but didn't work.
Please suggest.
Last edited by Scrutinizer; 12-18-2012 at 06:22 AM..
Reason: code tags
having a slight problem. any clues would help. Can't seem to get any output when I run a simple echo script.
grex.cyberspace.org% chmod a+x test
grex.cyberspace.org% ls -l test
-rwxrwx--x 1 gordybh cohorts 20 Dec 13 20:22 test
grex.cyberspace.org% cat test
#!/bin/sh
echo test... (2 Replies)
I have written a shell script which looks like below:
grep -v ',0,' ./DATA/abc.001 > ./DATA/abc.mid
egrep $GREPSEARCH ./DATA/ebc.mid > ./DATA/abc.cut
the variable GREPSEARCH has values like the below:
... (3 Replies)
does it make any difference in terms of performance while using any of the below mentioned code for the same requirement which processes continuously coming files in the I/P directory .
Please provide ur viewws
ls -tr $SAPRESPONSEGOFILE | sed "s/go/dat/g" |
while read SAPRESPONSEFILES... (3 Replies)
hello,
does anyone know how to expand the column width so it could contain full USER cell and not cut it in top ? Now it has eleven symbols but I can see only eight
actualy I found only PID, PPID and %CPU columns variation possibilities in changelog (procps v.3.2.5).
thanks in advance. (1 Reply)
Hi All
I have a flat text file. Each line in it contains a "/full path/filename". The last three columns are predictable, but directory depth of each line varies.
I want to sort on the last three columns, starting from the last, 2nd last and 3rd last. In that order. The last three columns... (6 Replies)
Hello Ya'all:
I hope Zaxxon is still around. I read a posting about compiling/updating the kernel from source. I'm doing a very specific upgrade, and am wondering if there is anything different or if there's an easy way to do this: I am using kernel version 2.6.18-92, and have done some... (1 Reply)
I use many different machines at work, each with different versions of o/s's and installed applications. Sed in vi is particularly inconvenient in the sense that sometimes it will accept the "\r" as a carriage return, sometimes not. Same thing with "\n". For instance, if I have a list of hosts... (7 Replies)
Hi
i have folder of 26 GB on server A and want to copy to server B .i used the below commands to check file size and scp copy
du -h /folder : its shows 26G on server A
from server B:
scp -r user@serverA:/folder/* ./copying got initiated and i am checking the file size on server B... (7 Replies)
I have a file like this:
ASSPASVFETQY,hTRBV12-4,hTRBJ2-5,2
ASSPASTGGDYGYT,hTRBV18,hTRBJ1-2,2
ASSPASGDGYT,hTRBV5-1,hTRBJ1-2,2
ASSPASFPEDTQY,hTRBV27,hTRBJ2-3,2
ASSPARVNYGYT,hTRBV5-1,hTRBJ1-2,2
ASSPARTSGGLNEQF,hTRBV6-4,hTRBJ2-1,2
ASSPARQSYNEQF,hTRBV11-1,hTRBJ2-1,2... (4 Replies)
Hello,
Currently i have a script which will disply the results in plain text format.
I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html and send that content as email.
Please help me how i can do that.
I am using... (10 Replies)
Discussion started by: joy lobo
10 Replies
LEARN ABOUT CENTOS
pmdapostgresql
PMDAPOSTGRESQL(1) Performance Co-Pilot PMDAPOSTGRESQL(1)NAME
pmdapostgresql - PostgreSQL database PMDA
DESCRIPTION
pmdapostgresql is a Performance Co-Pilot PMDA which extracts live performance data from a running PostgreSQL database.
INSTALLATION
pmdapostgresql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/postgresql/postgresql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdapostgresql.pl, namely:
o database name (see DBI(3) for details)
o database username
Once this is setup, you can access the names and values for the postgresql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Remove
pmdapostgresql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent
is installed or removed.
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/postgresql/postgresql.conf
configuration file for pmdapostgresql
$PCP_PMDAS_DIR/postgresql/Install
installation script for the pmdapostgresql agent
$PCP_PMDAS_DIR/postgresql/Remove
undo installation script for the pmdapostgresql agent
$PCP_LOG_DIR/pmcd/postgresql.log
default log file for error messages from pmdapostgresql
SEE ALSO pmcd(1), pmdadbping.pl(1) and DBI(3).
3.8.10 Performance Co-Pilot PMDAPOSTGRESQL(1)