Solved

navicat import cvs to postgresql

Posted on 2016-10-26
3
104 Views
Last Modified: 2016-10-28
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

0
Comment
Question by:teera
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
tel2 earned 500 total points
ID: 41861206
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
 
LVL 12

Expert Comment

by:tel2
ID: 41864895
Do the points mean I guessed right, teera?
Thanks.
0
 

Author Comment

by:teera
ID: 41864914
I think so  when I try to import file name with small letter such as   gd it not put "gd"   thank you
0

Featured Post

Webinar: Security & Encryption in the MySQL world

Join Percona’s Solutions Engineer, Dimitri Vanoverbeke as he presents “Security and Encryption in the MySQL world” on Thursday, July 6, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question