Top "Quoted-identifier" questions

Use this tag for questions involving SQL quoted (delimited) identifiers

Cannot simply use PostgreSQL table name ("relation does not exist")

I'm trying to run the following PHP script to do a simple database query: $db_host = "localhost"; $db_name = "showfinder"; $…

php sql postgresql quoted-identifier
PostgreSQL column 'foo' does not exist

I have a table that has 20 integer columns and 1 text column named 'foo' If I run query: SELECT * from table_…

sql postgresql quoted-identifier
PostgreSQL "Column does not exist" but it actually does

I'm writing a Java application to automatically build and run SQL queries. For many tables my code works fine but …

sql postgresql quoted-identifier
sql statement error: "column .. does not exist"

Im trying from postgres console this command: select sim.id as idsim, num.id as idnum from main_sim sim …

sql postgresql quoted-identifier
ERROR: column of relation does not exist PostgreSQL ,Unable to run insert query

Hi I am trying to insert into a table tester3 it fails when i use the syntax insert into tester3 (…

sql postgresql sql-insert quoted-identifier
Java SQL "ERROR: Relation "Table_Name" does not exist"

I'm trying to connect netbeans to my postgresql database. The connection seems to have worked as I don't get any …

java sql postgresql quoted-identifier
SQL Server XML Data Type and QUOTED_IDENTIFIER

Can anyone provide insight into this? I've developed an import process using an XML data type. After the data is …

sql-server xml quoted-identifier
I keep getting the error "relation [TABLE] does not exist"

I have been trying to query two tables in my database. In the server explorer I can see both tables …

sql postgresql quoted-identifier
Oracle ORA-00942: table or view does not exist when it exists

I'm trying to get used to Oracle, installed express one and created by 3rd part program some tables. And when …

sql oracle quoted-identifier
How I can create a table with oracle but with small characters?

How I can create a table with oracle but with small characters, when I create a table with small characters …

oracle quoted-identifier