While migrating the table data thru kettle tool from sql server to postgresql database getting below-
2023/03/15 16:59:52 - write to [REPORTS].0 - Caused by: org.postgresql.util.PSQLException: ERROR: column "NAME" of relation "reports" does not exist
Position: 56
SQL Server table ddl-
CREATE TABLE [dbo].[REPORTS](
[RID] [int] NOT NULL,
[NAME] nvarchar NULL,
[CATEGORY] [int] NULL,
[STATUS] [int] NULL,
[XML] nvarchar NULL,
[DESCRIPTION] nvarchar NULL)
Postgresql table ddl -
CREATE TABLE IF NOT EXISTS public.reports
(
rid integer NOT NULL,
name character varying(150),
category integer,
status integer,
xml character varying,
description character varying(255)
)