sqlserver2pgsql icon indicating copy to clipboard operation
sqlserver2pgsql copied to clipboard

Having reserved keywords as column name in postgresql table

Open arunchugh87 opened this issue 1 year ago • 0 comments

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) )

arunchugh87 avatar Mar 15 '23 17:03 arunchugh87