Run Postgres Command from Shell Script

Question

I Work with Postgresql. I have Command

shp2pgsql -I -s 4269  /tmp/t/Wards.shp aa | psql  postgis;

when i type su postgres and enter this command it works fine but from aa.sh file not

my aa.sh is

su postgres; shp2pgsql -I -s 4269  /tmp/gismanager/Wards.shp aa | psql  postgis;

Can anybody help me?

Michael Krelin - hacker · Accepted Answer · 2013-10-24 12:23:44Z

up vote 0 down vote accepted

You probably want something like

su posgres -c 'shp2pgsql… '

su command executes privileged shell, everything following it is executed after shell is terminated.

answered Oct 24 '13 at 12:23

Michael Krelin - hacker
56.1k3109131

add a comment |

1 Answer 1