0

So I have some sql in a varible. I could put that in a file and give it to psql as input but I wonder if there is an easy way to do this without the file ?

1
  • Can you add some more detail please? Maybe some information about how the variable was filled, what with, what you want it to do, what language you're working in, etc.
    – Majenko
    Mar 31, 2011 at 13:42

1 Answer 1

0

You can either pipe the command to psql

echo "$some_sql_in_a_varible" | psql -d mydatabase 

or use -c

psql -d database -c "$some_sql_in_a_varibl"

Mor info on the psql man page

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .