Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Having reserved keywords as column name in postgresql table #176

Open
arunchugh87 opened this issue Mar 15, 2023 · 0 comments
Open

Having reserved keywords as column name in postgresql table #176

arunchugh87 opened this issue Mar 15, 2023 · 0 comments

Comments

@arunchugh87
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant