BTW - I’ve tried figuring out myself and understood UNION workaround could
help, but since it’s via pg-sample so just want to understand if there a quick
workaround without tweaking pg-sample itself.
> On 24-Aug-2018, at 6:20 PM, Abhinav Mehta <abhi...@metarain.com> wrote:
>
> Hi Team,
>
> I’m getting running into following issue while executing pg-sample
>
> Error
> ====
> DBD::Pg::db do failed: ERROR: could not identify an equality operator for
> type json
> LINE 3: SELECT DISTINCT t1.*
> ^ at ./pg_sample line 296.
> main::__ANON__("DBD::Pg::db do failed: ERROR: could not identify an
> equality"..., DBI::db=HASH(0x1704258), undef) called at ./pg_sample line 638
> /pg_sample$ ./pg_sample mydb | psql sampledb
> ====
>
> Executing Command
> ====
> pg_sample mydb | psql sampledb
> ====
> —
> Thanks
> Abhinav
