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

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 Jun 28 '17 at 15:36 — Durga Gaddam, Jun 28 '17 at 15:36

score 10 · Answer 1 · answered Jun 28 '17 at 15:43

10

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 '17 at 15:43

Anuraag Veerapaneni

639
4
15

It worked, thank you @Anuraag – Durga Gaddam Jun 28 '17 at 15:53
Double quotes also works when selecting a column with a dot. – Freeze Apr 16 '20 at 09:37

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

1 Answers1