cut for whole lines

[steve crandell]

Consider appending --tuples-only if you're generating this list with psql.

To your question specifically, this should do it:
cat my_tables.txt  | grep -v "\-\-\-" | grep -v ^$ | tail -n +2 | head 
-n -1

Though that uses magical hard coded characters which will get you in 
trouble later when one little thing about the output you're parsing 
changes.  

Frankly I'd use the perl DBI.

-s

Craig White wrote:
> I am trying to script reading the table info from postgres into a file.
>
> I need to get rid of the first 2 and last 2 lines and it should be easy
> but obviously cut is for grabbing bits of lines where I need to remove
> the whole line.
>
> # cat my_tables.txt
>        tablename
> -----------------------
>  engine_schema_info
>  plugin_schema_info
> ...snipped here...
>  services
> (43 rows)
>
> I need to lose the top 2 lines:
>       tablename
> ---------------
>
> and the bottom two lines
> (43 rows)
> and a blank line (though this would probably be OK)
>
> how do I accomplish via bash or coreutils (like cut)?
>
> Thanks
>
> Craig
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>   

-- 
Steve Crandell
Linux System Operations

    480.282.6047 direct
    480.239.9286 mobile
    480.505.5801 fax
    steven.crandell at icrossing.com
    www.icrossing.com

    ATLANTA | CHICAGO | DALLAS | NEW YORK | SAN FRANCISCO | SCOTTSDALE
    Winner of OMMA Magazine's 2005 Agency of the Year: Best Search