UNIX for Dummies Questions & Answers

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.

Just check how many lines of your message has header files.

Assume it first two lines are header file here.. use

Code:

 "psql -c "\dt" | awk 'NR>2{print$3}'"

From what we can see in the desired output, it should start with line 4, so pamu's proposal should be slightly modified to using NR>3.

It worked just fine and perfect for me.
Thanks pamu and Rudic.