I'm trying to run the following PHP script to do a simple database query: $db_host = "localhost"; $db_name = "showfinder"; $username = "user"; $password = "password"; $dbconn = pg_connect("host=$d...

I'm writing a Java application to automatically build and run SQL queries. For many tables my code works fine but on a certain table it gets stuck by throwing the following exception: Exception in...

I'm having this strange problem using PostgreSQL 9.3 with tables that are created using qoutes. For instance, if I create a table using qoutes: create table "TEST" ("Col1" bigint); the table is ...

I have a table that has 20 integer columns and 1 text column named 'foo' If I run query: SELECT * from table_name where foo is NULL I get error: ERROR: column "foo" does not exist I have che...

Hi I am trying to insert into a table tester3 it fails when i use the below syntax insert into tester3 (UN0, UN1) values ( 1, 'jishnu1'); but below insert insert into tester3 values ( 1, 'jishnu1'...

Let's consider the following postgres query: SELECT * FROM "MY_TABLE" WHERE "bool_var"=FALSE AND "str_var"='something'; The query fails to respond properly when I remove quotes around "str_va...

I have recently tried to create some tables in PostgreSQL all in uppercase names. However in order to query them I need to put the table name inside the quotation "TABLE_NAME". Is there a...

I have been trying to query two tables in my database. In the server explorer I can see both tables and even see the columns within them. We'll call them Schema.table1 and Schema.table2 where "Sche...

There are plenty of questions here on SO and articles online about how to handle this mess, but my question is more fundamental: WHY? Quoted identifier seems to be a property of how the engine inte...

How I can create a table with oracle but with small characters, when I create a table with small characters it converts auto to capital characters.

Im trying from postgres console this command: select sim.id as idsim, num.id as idnum from main_sim sim left join main_number num on (FK_Numbers_id=num.id); and I've got this response: ER...

I'm new to Postgresql and I'm trying to migrate my application from MySQL. I have a table with the following structure: Table "public.tbl_point" Column | Type | Modifiers | Storage | Description...

Can anyone provide insight into this? I've developed an import process using an XML data type. After the data is inserted in to a table by the import sProc I run another procedures to update anoth...