0

Need small help

I want to execute Select * from emp in Mule(transform message) using PostgresSQL but it is not taking * instead it is taking only column names like empno,ename,firname etc.. but I want to use * as my table is having almost 100 plus columns.

Can anyone suggest how to handle ?

satya
  • 1
  • 1
  • Please edit your comment and add the operation or operations in the flow that you are trying to execute, as text XML. Don't use screenshots. What is the result if you try using *? is there an error, an unexpected result, what? show that too. – aled Nov 10 '21 at 03:12
  • Note that using `select *` is usually considered a bad practice: https://stackoverflow.com/questions/3639861/why-is-select-considered-harmful – aled Nov 10 '21 at 03:14
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – Community Nov 13 '21 at 20:55

0 Answers0