Is it possible to execute query in shell script??

[lakk]

Having a database created, is it possible to excute queries on this database from a shell script file??

[rski]

You mean something like that

psql database_name < file.sql

or that

psql database_name -f file.sql

[lakk]

Can you explain ur answer further..i dont get what you mean..

[rski]

If you have a shell script and you want to call queries from this script you can do it using psql client. Queries you can put into file and use -f paremeter or you can use -c parameter and put queries explicitly

psql databasename -c "<query>"

Do you understand now?