Select Code to Download

create server abc_server foreign data wrapper file_fdw;
create foreign table file_table ( c1 text, i2 int, i3 int)
    server abc_server
...
     , rank() over (order by i3 desc)
from file_table
order by c1;

$ psql -qXf table.sql 
 c1 | i2 | i3 
...
 d  |    5 |    5
 e  |    1 |    1
(5 rows)