Postgres sql insert query syntax error from phpPgAdmin

by

I’ve installed phpPgAdmin to try to reproduce your error. I got it right away when tried to create a test table:

enter image description here

So looks like phpPgAdmin wraping your query into select count(*) as total from (...). I’ve found that it happens only when checkbox “Paginate results” on query page is set to on (obviously phpPgAdmin trying to count how many rows it will get and then show it page by page). Uncheck it and your query will work fine:

enter image description here

updated 1

Similar question – INSERT INTO PostgreSQL

updated 2

As @akshay mentioned in comments, you also could get similar error running the queries through the command line, see explained situation and answer here – PostgreSQL disable more output

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. PostgreSQL “Column does not exist” but it actually does
  3. Is SELECT or INSERT in a function prone to race conditions?
  4. Index for finding an element in a JSON array
  5. Query for array elements inside JSON type
  6. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  7. Is it possible to make a recursive SQL query?
  8. Way to try multiple SELECTs till a result is available?
  9. Column ‘mary’ does not exist
  10. Get top row(s) with highest value, with ties
  11. Double colon `::` notation in SQL
  12. Delete parent if it’s not referenced by any other child
  13. Window Functions: last_value(ORDER BY … ASC) same as last_value(ORDER BY … DESC)
  14. PostgreSQL: how to convert from Unix epoch to date?
  15. SQL update fields of one table from fields of another one
  16. Postgres – Function to return the intersection of 2 ARRAYs?
  17. How to store array or multiple values in one column
  18. Which datatype should be used for currency?
  19. How to return two columns with function
  20. COPY with dynamic file name
  21. Table or column name cannot start with numeric?
  22. Count cumulative total in Postgresql
  23. PostgreSQL column ‘foo’ does not exist
  24. Prepared Statement on Postgresql in Rails
  25. How to detect query which holds the lock in Postgres?
  26. PostgreSQL how to create a copy of a database or schema?
  27. PostgreSQL: fill NULL values in timeserie query with previous value
  28. Postgres: convert single row to multiple rows (unpivot)
  29. Get most common value for each value of another column in SQL
  30. PostgreSQL: top n entries per item in same table

Leave a Comment