Postgresql tables exists, but getting “relation does not exist” when querying

You have to include the schema if isnt a public one

SELECT *
FROM <schema>."my_table"

Or you can change your default schema

SHOW search_path;
SET search_path TO my_schema;

Check your table schema here

SELECT *
FROM information_schema.columns

For example if a table is on the default schema public both this will works ok

SELECT * FROM parroquias_region
SELECT * FROM public.parroquias_region

But sectors need specify the schema

SELECT * FROM map_update.sectores_point

Related Posts:

  1. missing FROM-clause entry for table
  2. Insert text with single quotes in PostgreSQL
  3. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  4. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  5. postgresql: error duplicate key value violates unique constraint
  6. pg_ctl: no database directory specified and environment variable PGDATA unset
  7. Postgres Error: More than one row returned by a subquery used as an expression
  8. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  9. PostgreSQL create table if not exists
  10. updating table rows in postgres using subquery
  11. PostgreSQL visual interface similar to phpMyAdmin?
  12. GROUP BY and COUNT using ActiveRecord
  13. Postgresql column reference “id” is ambiguous
  14. What is a postgres superuser
  15. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  16. SQL WITH clause example [duplicate]
  17. The wait operation timed out. ASP
  18. Conversion failed when converting date and/or time from character string while inserting datetime
  19. how to fix oracle ORA-01722 invalid number error
  20. SQL query to select dates between two dates
  21. MySQL – Operand should contain 1 column(s)
  22. SQL SELECT WHERE field contains words
  23. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  24. NOT IN vs NOT EXISTS
  25. Must declare the scalar variable
  26. MySQL query String contains
  27. How do I escape a single quote in SQL Server?
  28. T-SQL split string based on delimiter
  29. Finding duplicate values in a SQL table
  30. MySQL Cannot Add Foreign Key Constraint
  31. mysql Foreign key constraint is incorrectly formed error
  32. Can a foreign key be NULL and/or duplicate?
  33. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  34. How do composite indexes work?
  35. Difference between JOIN and INNER JOIN
  36. MySQL “WITH” clause
  37. What is the difference between JOIN and UNION?
  38. MySQL Multiple Joins in one query?
  39. Error Code: 2013. Lost connection to MySQL server during query
  40. “CASE” statement within “WHERE” clause in SQL Server 2008
  41. SQL join on multiple columns in same tables
  42. Sql query – getting rid of hard-coded values
  43. ORA-00918: column ambiguously defined in SELECT *
  44. Combining “LIKE” and “IN” for SQL Server
  45. How To Run A Github Repository?
  46. SQL Switch/Case in ‘where’ clause
  47. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  48. SQL Server WITH statement
  49. How to run a SQL query on an Excel table?
  50. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  51. Oracle “Partition By” Keyword
  52. What is the equivalent of ‘describe table’ in SQL Server?
  53. Add a column with a default value to an existing table in SQL Server
  54. Remote table-Valued Function Calls are not allowed
  55. The backend version is not supported to design database diagrams or tables
  56. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  57. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  58. Using group by on multiple columns
  59. What is the purpose of using WHERE 1=1 in SQL statements?
  60. How do you force mysql LIKE to be case sensitive?
  61. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  62. What is the difference between a stored procedure and a view?
  63. Bulk load data conversion error (truncation)
  64. Insert into a MySQL table or update if exists
  65. Convert timestamp to date in Oracle SQL
  66. How to order by with union in SQL?
  67. Can I use multiple “with”?
  68. Incorrect syntax near ”
  69. MySQL: Can’t create table (errno: 150)
  70. Join vs. sub-query
  71. Alternative to except in MySQL
  72. DATEDIFF function in Oracle
  73. MySQL – Get row number on select
  74. Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
  75. Difference between EXISTS and IN in SQL?
  76. What does * mean in sql?
  77. How to truncate the text returned for a column in a MySQL query
  78. What’s the best way to dedupe a table?
  79. Moving database with phpMyAdmin
  80. How To Write An Inner Join With WP Query
  81. How do I escape a table name or column name in SQL? esc_sql doesn’t do this
  82. Update user_login, user_nicename, and display_name
  83. Change sticky status of posts from phpMyAdmin
  84. Best Way to Merge a Dev and Live Site to Become a Staging Site?
  85. How to import a Typo3 database to a wordpress site?
  86. What does the $posts_join filter join to?
  87. Clean up very big and very dirty database
  88. How to delete ALL comments from certain category in WordPress database?
  89. How can I convert everything from category X to have post format Link
  90. Bulk delete WordPress Post and all metadata, etc using SQL query
  91. Reset post IDs with all post meta
  92. How to Add or Change Post Title
  93. Why does DROP TABLE-ing the `wp_options` reset my user session?
  94. How to refactor DB queries for better TTFB in WordPress?
  95. query sql-table and change entities
  96. Duplicate WP Migration affecting site on separate domain?
  97. Analog category_and (WP) in sql query
  98. Backtick (MySQL norm) added to SQL Server Query causing error
  99. SQL query to check whether a meta key is set or not for a post in post_meta table
  100. GRANT SELECT to all tables in postgresql

Leave a Comment