navicat import cvs to postgresql

I use navicat import cvs to postgresql    why it is not   CREATE TABLE public.AH
but it do CREATE TABLE public."AH"

then when I select     must be public."AH"   some table I import with navicat. some table it have already with out " "  

CREATE TABLE public."AH"
(
  "Timestamp" character varying(255),
  "Last" character varying(255),
  "Trade Price" character varying(255),
  "Trade Volume" character varying(255),
  "Best Bid" character varying(255),

Open in new window

teeraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tel2Connect With a Mentor Commented:
Hi teera,

I assume this is to cater for strings which contain spaces.

I think that's the reason they have quotes around column names, like "Trade Price", so it's probably the same reason.

But I'm just guessing.
0
 
tel2Commented:
Do the points mean I guessed right, teera?
Thanks.
0
 
teeraAuthor Commented:
I think so  when I try to import file name with small letter such as   gd it not put "gd"   thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.