Postgresql Commands

1. Collumn Count:

select count(*) from information_schema.columns

                  where table_name='tm_ctrl';

2. Select query with LIMIT OFFSET:

select * from td_nyukin limit 5 offset 0

N.B: i) LIMIT: How much row will be shown here
        ii) OFFSET: Start from which position