Select in postgresql using php

Question

I cant properly select some data in the database i made. I used postgresql. The error says "Error in SQL query: ERROR: relation "book_flight.customer" does not exist LINE 1: SELECT idno FROM book_flight.customer ^" I tried removing the book_flight, still doesn't work

here is the code:

<?php  

    $db = pg_connect("host=localhost port=5432 dbname=AIRLINE user=postgres password=code");  
    echo 'Connected to: ', pg_dbname($db);

    $result = pg_query($db, "SELECT idno FROM book_flight.customer");
    if (!$result) {
        die("Error in SQL query: " . pg_last_error());
    } 

?>

table customer is in the schema named book_flight

Do you have a customer column ? – Serhat Akay Oct 04 '13 at 11:54 — Serhat Akay, Oct 04 '13 at 11:54
please ignore, cannot del comment. – asantaballa Oct 04 '13 at 11:57 — asantaballa, Oct 04 '13 at 11:57

score 1 · Answer 1 · edited May 23 '17 at 11:50

1

Take a look at this, sounds like names may be case sensitive.

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

edited May 23 '17 at 11:50

Community

1
1

answered Oct 04 '13 at 11:58

asantaballa

3,919
1
21
22

score 1 · Answer 2 · answered Oct 06 '13 at 03:39

1

I changed the database name, schema, and table name to small letters. It works. Seems that postgresql changes all to lower case and is case sensitive

answered Oct 06 '13 at 03:39

Sho Locus

21
2

Select in postgresql using php

2 Answers2