I have a non-spatial table (PostGIS) in QGIS with one column only. Whenever I paste value on that table from data on Google Sheet or from Notepad, it will paste null value even it has an actual text value.

What is the proper way to copy and paste data/value on a non-spatial table?

This is the steps I did:

  1. Open the Attribute Table of that non-spatial table and toggle edit mode
  2. From Google Sheet, I just copy for example 3 rows with just numbers on it
  3. Then I paste it on the Attribute Table
  4. A prompt window will appear to "Fix Pasted Features" because I activate the "Enforce Null Constraint" and since the value pasted is null (even it has value on it)
  • PostGIS is a spatial type implementation in PostgreSQL. A nonspatial PostGIS table is a non sequitur.
    – Vince
    Mar 3 at 3:52
  • 2
    It would help if you edited your original post to explain the exact steps you use to copy and paste. Screenshots would also help.
    – Stu Smith
    Mar 3 at 4:47
  • I added the steps I made as suggested... Mar 5 at 23:41
  • The problem continues if the field is of character data type? Mar 6 at 4:11
  • why is it a problem if the field is a character data type? the source data is a character type even though the value is a number actually if the source value is "abc" then paste it to that non-spatial table, it will detect as a null value... I just don't understand why Mar 7 at 3:14


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.