current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite 
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
share|improve this question

1 Answer 1

up vote 1 down vote

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'
}
share|improve this answer
    
thanks Erwin just one more question I need to use variable value inside copy function while writing in .csv format –  user3526905 Feb 25 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. –  Erwin Brandstetter Feb 25 at 7:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.