Page 3 of 6 FirstFirst 12345 ... LastLast
Results 21 to 30 of 57

Thread: Which Database Do You Prefer

  1. #21
    girldemsuga Guest

    Default

    I tried out the PostgreSQL, using pgAdmin III, i create a database named TestDB and a Table named Students(StudentID, FName, LName).
    I then clicked the SQL button to write some queries but for some strange reason, i not able to query the Students table; I able seeing the table in the UI but not able to query using the SQL Tool provided with the Software.
    Later i SQL Tool to create another table named Loves and I am able to query that table.
    What am i doing wrong?
    The picture below is a screen shot.

    Last edited by girldemsuga; Sep 7, 2006 at 04:29 PM.

  2. #22
    Join Date
    Mar 2003
    Posts
    492
    Rep Power
    0

    Default

    Your problem is in the query. By default Postgres selects on the 'public' schema the name of the table in lowercase. You have 'Students' which when converted to lowercase does not exist in the 'public' schema.

    Use this instead
    Code:
    SELECT * FROM "Students"
    This tells it to search in the public schema on the table that is literally Students (with the uppercase 'S').

    Good luck.

  3. #23
    girldemsuga Guest

    Default

    PostgreSQL is case sensative, it there a way to disable this?

  4. #24
    Join Date
    Apr 2004
    Posts
    537
    Rep Power
    0

    Default

    No you can't disable it sorry
    Wise men talk because they have something to say; fools, because they have to say something. Live for computers or else they will live for you.
    8368993 (lime) 303-1359 (digi) blunt60us@yahoo.com

  5. #25
    Join Date
    Mar 2003
    Posts
    492
    Rep Power
    0

    Default

    Looks to be part of the SQL Syntax enforced by Postgres.

    Here's a quick look - SQL Syntax and Names

  6. #26
    girldemsuga Guest

    Default

    What I will do then is use lower case for everything, I am use to DB's which are not case senetive.

  7. #27
    Join Date
    Mar 2004
    Posts
    421
    Rep Power
    0

    Default

    i ahev used all of wat u guys ahave already mentioned...but there is another one out there.. "postgres"...its in teh same class as oracle.... platform independent !
    OvErSiZeSpAdE

  8. #28
    girldemsuga Guest

    Default

    Is there any advantage to having a Databse Engine (PostgreSQL) which is case sensative.
    To tell you the truth, i dont like it and it's more of an annoyance on my part.

  9. #29
    Join Date
    Mar 2003
    Posts
    492
    Rep Power
    0

    Default

    Quote Originally Posted by girldemsuga View Post
    Is there any advantage to having a Databse Engine (PostgreSQL) which is case sensative.
    To tell you the truth, i dont like it and it's more of an annoyance on my part.
    Probably not. But if it is such a bother, Oracle has a free DB which is good I hear.

  10. #30
    Join Date
    Dec 2002
    Posts
    500
    Rep Power
    0

    Default

    Oracle has free database... Interesting.
    Anybody use it, what features have they watered out?
    Cultured in Aggression and Koding like a Warrior!!
    “Common sense is instinct. Enough of it is genius.” - George Bernard Shaw.
    "The significant problems we face cannot be solved by the same level of thinking that created them." - Albert Einstein

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •