How to create column name with dot(".") in PostgreSQL [duplicate]

Question

I am trying to create a table in PostgreSQL, but I am getting an error create table bond ([Coupon.Type] varchar(35),[Coupon.Index] varchar(35),[Tranche.1] varchar(35),[Tranche.2] varchar(35)) I have tried removing the "[" and as Coupon.Type,also "Coupon.Type" but nothing works.

ERROR: syntax error at or near "[" LINE 1: Room varchar(35),(Coupon.Type) varchar(35),[Coupon.Index] va...

@AlexK. I have used the quotes but its not working

Durga Gaddam
– Durga Gaddam

2017-06-28 15:36:07 +00:00
Commented Jun 28, 2017 at 15:36 — Durga Gaddam
– Durga Gaddam, Commented Jun 28, 2017 at 15:36

Anuraag Veerapaneni · Accepted Answer · 2017-06-28 15:43:50Z

12

This will work

create table bond ( "Coupon.Type" varchar(35) ,"Coupon.Index" varchar(35) ,"Tranche.1" varchar(35) ,"Tranche.2" varchar(35) )

answered Jun 28, 2017 at 15:43

Anuraag Veerapaneni

6795 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Durga Gaddam Over a year ago

It worked, thank you @Anuraag

Freeze Over a year ago

Double quotes also works when selecting a column with a dot.

Collectives™ on Stack Overflow

How to create column name with dot(".") in PostgreSQL [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related