0 
PG_CMD="psql -d portal -U portal -c "
PG_CMD_TP="psql -d portal -U portal -t -P format=unaligned -c "
abc()
{
 $PG_CMD " 
        DO \$$

           BEGIN
                   select * from customer;
          END; 
        \$$";
}
*******MAIN***
abc

I want to print result of query on command line as well as I want to send it to excel file.

ERROR:  query has no destination for result data
Improve this question

1 Answer 1

Reset to default
2

Three misunderstandings:

  1. You cannot return data from a DO command.

  2. You cannot SELECT without target in plpgsql code. That's what the error message tells you.

  3. You don't need either for a simple SELECT statement. Just run the statement itself:

abc()
{
 $PG_CMD 'select * from customer'
}
Improve this answer
2
  • thanks Erwin just one more question I need to use variable value inside copy function while writing in .csv format Commented Feb 25, 2015 at 7:10
  • @user3526905: That's seems like an unrelated question. Please start a new question, comments are not the place. Or consider related question on SO like here or here. Commented Feb 25, 2015 at 7:15

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.