sqlserver2pgsql
sqlserver2pgsql copied to clipboard
Having reserved keywords as column name in postgresql table
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) )