- Query Syntax
- SQL
- Databases
- Microsoft Access
- Microsoft SQL Server 2008
Issue to run query
Hi,
What is wrong below? Is it the place to run query?
![8a.png]()
What is wrong below? Is it the place to run query?
Nothing is wrong with the syntax. If you are using copy/paste, make sure there aren't any special characters in the text.
I suspect the problem is because you have broken the single SQL query across multiple input lines.
Try typing it all on a single line to see if that works, like below. If that works then you will have to look for information on how the psql command line wants you to input multiple lines, I don't recall off hand.
»bp
Try typing it all on a single line to see if that works, like below. If that works then you will have to look for information on how the psql command line wants you to input multiple lines, I don't recall off hand.
SELECT * FROM pg_catalog.pg_tables WHERE schemaname != 'pg_catalog' AND schemaname != 'information schema';
»bp
Sorry, I'd still try the test above, but I see that the prompt did change in your screenshot, so it appears it handled the multi-line input okay.
Did you type those lines in, or paste them? As mentioned above, if pasted it could be a non-visible character (like a TAB) that is causing a problem perhaps?
»bp
Did you type those lines in, or paste them? As mentioned above, if pasted it could be a non-visible character (like a TAB) that is causing a problem perhaps?
»bp
Are you pasting it in or manually typing it in?
I still say invalid character. If you are using a UTF editor, it might not be a space character you are pasting.
You aren't answering our questions.
Are you physically typing into the psql window or pasting the command into it?
So you are no longer getting the error on the "*" in the query, what did you do differently to get past that???
»bp
»bp
>> I am pasting query into that.
Then you need to make sure you are pasting what you think you are pasting. Something you are pasting isn't correct.
You need to try TYPING the whole query in, not PASTING it. That will help determine if there are "special characters" in the source that you are COPYING from, and help guide a solution for that mode. But do a test TYPING first.
»bp
»bp
It is strange. Nothing is special below:
SELECT * FROM pg_catalog.pg_tables WHERE schemaname <> 'pg_catalog' AND schemaname <> 'information_schema';
Premium Content
You need an Expert Office subscription to comment.Start Free Trial