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

From what I’ve read, this error means that you’re not referencing the table name correctly. One common reason is that the table is defined with a mixed-case spelling, and you’re trying to query it with all lower-case.

In other words, the following fails:

CREATE TABLE "SF_Bands" ( ... );

SELECT * FROM sf_bands;  -- ERROR!

Use double-quotes to delimit identifiers so you can use the specific mixed-case spelling as the table is defined.

SELECT * FROM "SF_Bands";

Re your comment, you can add a schema to the “search_path” so that when you reference a table name without qualifying its schema, the query will match that table name by checked each schema in order. Just like PATH in the shell or include_path in PHP, etc. You can check your current schema search path:

SHOW search_path
  "$user",public

You can change your schema search path:

SET search_path TO showfinder,public;

See also http://www.postgresql.org/docs/8.3/static/ddl-schemas.html

Related Posts:

  1. Data source name not found, and no default driver specified
  2. PDO with INSERT INTO through prepared statements
  3. Creating a search form in PHP to search a database?
  4. How can I do ‘insert if not exists’ in MySQL?
  5. Commands out of sync; you can’t run this command now
  6. How can I do ‘insert if not exists’ in MySQL?
  7. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  8. Fatal error: Call to a member function query() on null
  9. How to set 777 permission on a particular folder? [closed]
  10. regex match any whitespace
  11. PHP page redirect
  12. How do I resolve a HTTP 414 “Request URI too long” error?
  13. xajax expanding list query
  14. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  15. How do I redirect a page in jQuery?
  16. mcrypt is deprecated, what is the alternative?
  17. Fatal error: Call to undefined function mysqli_connect()
  18. Illegal string offset Warning PHP
  19. What’s the purpose of ini_set() in php? (especially for error reporting)
  20. .rar, .zip files MIME Type
  21. Send email with PHP from html form on submit with the same script
  22. Forbidden :You don’t have permission to access /phpmyadmin on this server
  23. How do I run a file on localhost?
  24. How to call a JavaScript function from PHP?
  25. Print array to a file
  26. I have a string with “\u00a0”, and I need to replace it with “” str_replace fails
  27. Finding the number of days between two dates
  28. MySqli Commands out of sync; you can’t run this command now
  29. Trying to get property of non-object in
  30. CURL ERROR: Recv failure: Connection reset by peer – PHP Curl
  31. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  32. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  33. “Cannot send session cache limiter – headers already sent”
  34. Unable to locate package libapache2-mod-php7
  35. How to create cron job using PHP?
  36. Imploding an associative array in PHP
  37. curl POST format for CURLOPT_POSTFIELDS
  38. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  39. Can’t use method return value in write context
  40. PHP get domain name
  41. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  42. postgresql: error duplicate key value violates unique constraint
  43. Running a Python script from PHP
  44. Object of class DateTime could not be converted to string
  45. HTTP Error 411, The request must be chunked or have a content length
  46. mysqli::query(): Couldn’t fetch mysqli
  47. Fatal error: Call to undefined function sqlsrv_connect()
  48. NotFoundHttpException in RouteCollection.php line 161: in laravel 5
  49. Easy way to password-protect php page
  50. Html encode in PHP
  51. file_put_contents: Failed to open stream, no such file or directory
  52. PHP json_decode() returns NULL with valid JSON?
  53. Why do I have to run “composer dump-autoload” command to make migrations work in laravel?
  54. PHP $_POST not working?
  55. PHP cURL HTTP PUT
  56. Convert timestamp to readable date/time PHP
  57. PHP sessions that have already been started
  58. Contact Form 7 – Custom Validation
  59. How to output JavaScript with PHP
  60. WRONGTYPE Operation against a key holding the wrong kind of value php
  61. What is the advantage of using try {} catch {} versus if {} else {}
  62. PostgreSQL create table if not exists
  63. Check if URL has certain string with PHP
  64. Subtracting days, months or years from date using php
  65. Laravel – Model Class not found
  66. Fatal error: Call to a member function fetch_assoc() on a non-object
  67. Strict Standards: Only variables should be assigned by reference PHP 5.4
  68. mysqlworkbench giving version error on exporting database
  69. Steam Market API?
  70. PHP array delete by value (not key)
  71. GROUP BY and COUNT using ActiveRecord
  72. PHP mail: Multiple recipients?
  73. Having a problem getting mysqli_query to execute
  74. PHP Multiple Checkbox Array
  75. Session variables not working php
  76. How get value from URL
  77. Get JSON object from URL
  78. How can I parse a JSON file with PHP? [duplicate]
  79. Object of class stdClass could not be converted to string
  80. How to push both value and key into PHP array
  81. Find the last element of an array while using a foreach loop in PHP
  82. Popup window in PHP?
  83. How can you use php in a javascript function
  84. How to bypass (deprecated) reCAPTCHA V1?
  85. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  86. Transaction when using WP functions rather than vanilla SQL?
  87. Display data from a non wordpress database on a page template
  88. How to auto login user again after change user_login
  89. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  90. Transferring working local PHP site to wordpress – with database (MySQL)
  91. Detect session/cookie variable in wordpress to prevent access to documents
  92. PHP -> SQL Query with Summing
  93. Remove password protection from all posts
  94. WordPress SQL Prepare
  95. How to get database connection details without longing to cpanel in WordPress?
  96. How To Toggle User_Meta in frontend in a form using PHP
  97. Getting error in sql query
  98. Front end/Database connection in WP
  99. SQL Query Search page
  100. How to export database correctly for local to online

Leave a Comment