``` syntax error at or near varchar LINE 14 CAST uuid varcha Meltano #announcements

``` syntax error at or near "varchar" LINE 14: ...

raj

12/12/2019, 5:24 AM

Copy code

syntax error at or near "varchar"
  LINE 14:         CAST (uuid varchar(40))             as uuid,
                              ^

How can I create a varchar in the analyze db?

yannis_roussos

12/12/2019, 9:49 AM

In Postgres, the syntax for Cast is:

CAST (x AS type)

6 Views