No announcement yet.

Support edit VIEW as TABLE for PostgreSQL

  • Filter
  • Time
  • Show
Clear All
new posts

  • Support edit VIEW as TABLE for PostgreSQL

    Navicat is support edit editable VIEW as TABLE for PostgreSQL? If not, when you plan to do?
    Last edited by Vladimir; 02-17-2017, 06:37 AM.

  • #2
    Hi Vladimir,

    Would you please provide us your Navicat version? e.g.

    Navicat for PostgreSQL (Windows) 11.2.15


    • #3
      Navicat for PostgreSQL (Windows) 11.2.14.
      And type numeric wrong display in Navicat. For example: Numeric(20, 0). Number 12345678901234567890 correct display in PgAdmin. In Navicat crash last digits.


      • #4
        I am sorry that Navicat does not allow editing data in PostgreSQL View. Your request has been forwarded to our development team. We will keep improving Navicat in future.

        For the numeric wrong display issue, could you please provide us the following information? You can send the information to -

        1. The table sql with sample data. In Navicat, right-click the table and choose Dump SQL File > Structure And Data
        2. What do you mean by "crash last digits"? Please describe more.
        3. Screenshots showing the problem and detailed steps to reproduce it.


        • #5
          CREATE TABLE public."TestNumeric"
          id int NOT NULL,
          "value" numeric(20,0),
          CONSTRAINT "TestNumeric_pkey" PRIMARY KEY (id)

          Then open table in Navicat and input: id = 1, value = 12345678901234567890. After press enter value is crush. 1.23456789012346E19 is not correct. Type numeric(20,0) is equivalent integer type with 20 digits.


          • #6
            Please upgrade to version 11.2.16 to see if it can solve the reported problem. You can simply choose Help > Check For Updates in the menu bar.


            • #7
              Thanks! In version 11.2.16 numeric type work correct.