Escaping * in SQL query from shell

I am trying to run a sql query from a c++ program on Solaris 10. It is
simple like:
select * from table
but unfortunately shell takes * as its own wildcard and transforms
query as
select file1 file2 file3 file4 from table
where file1,2,3,4 are files in the folder from where I am executing
the program.

Any idea how can I escape this *?

thanks
ps

.

Relevant Pages

  • escaping * in a program from shell?
    ... I am trying to run a sql query from a c++ program on Solaris 10. ... but unfortunately shell takes * as its own wildcard and transforms ... Any idea how can I escape this *? ...
    (comp.os.linux.development.apps)
  • Re: escaping * in a program from shell?
    ... I am trying to run a sql query from a c++ program on Solaris 10. ... -- Munich Schoolmaster, to Albert Einstein, age 10 ...
    (comp.os.linux.development.apps)
  • Re: Which one is better between these two approaches?
    ... I have a method called sqlQueryBD which receives a string sql query and executes it against a database. ... The purpose of this class to translate the receiving sql query into an "escaped" sql query, ... When you have put together the values into a query, it's too late to safely escape the values. ... How should the code know that the fourth and fifth apostrophes are to be escaped? ...
    (microsoft.public.dotnet.languages.csharp)
  • Displaying SQL Execution time from DBI...
    ... In the shell when you run an SQL query it displays the execution time ... it took ) from DBI is there a way to ...
    (perl.dbi.users)