Aqua Data Studio 15.0.0-dev-70
Build #: 35519
Built on: 2014-Jan-13 03:38:49 PM

Operating Environment:  Windows7 64-bit
Database: Greenplum 4.2
Issue : Single quote is not getting generated for money datatype in insert script.

Steps to reproduce:

1.Run following scripts on query analyser
       CREATE TABLE "public"."table_money"  (

         "c1_money"      money NOT NULL

         )

      DISTRIBUTED BY ("c1_money")

      GO

3.Goto table tree node
   Select table “table_money”, Right click  and select “Script Object to Window As”->INSERT
   It generates script like :
    INSERT INTO "public"."table_money"("c1_money")

        VALUES(0.00)

     GO

4. When we insert values in this script it gives error that
“ERROR: column "c1_money" is of type money but expression is of type numeric
  Hint: You will need to rewrite or cast the expression.”

5. Now insert value for bit in single quotes, record inserted successfully.
INSERT INTO "public"."table_money"("c1_money")

        VALUES('5.00')

GO