StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POImport csv file into psql db
primarykey
Id
11363005
data
AcceptedAnswerId
11363293
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-07-06T13:21:10.393
FavoriteCount
4
LastActivityDate
2012-07-09T17:45:45.857
LastEditDate
2012-07-09T14:01:29.720
LastEditorUserId
1437504
OwnerUserId
1437504
ParentId
0
PostTypeId
1
Score
1
ViewCount
10975
LastEditorDisplayName
text
Body
I want to import csv file to psql db... I have searched and tried using copy, also referred <a href="https://www.commandprompt.com/ppbook/r23528" rel="nofollow">https://www.commandprompt.com/ppbook/r23528</a> and the syntax i used is: <pre><code>copy location from 'file.csv' with delimiters '\t' NULL as 'NULL' CSV; </code></pre> Note : My csv file is delimited by 'tab' . After executing the above cmd 1st time, it shows : <pre><code>ERROR: syntax error at or near ""\t"" LINE 1: ...om 'file.csv' using delimiters "\t" ; </code></pre> and for 2nd time, <pre><code>ERROR: syntax error at or near "copy" LINE 2: copy location from 'file.csv' using d... </code></pre> After Editing, 2nd time i tried to use like , <pre><code>copy location from 'file.csv' with delimiter E'\t' NULL as 'NULL' CSV; ERROR: extra data after last expected column CONTEXT: COPY location, line 1: "AD AD100 Canillo 42.5833 1.6667 6" </code></pre> My table description is <pre><code>Table "public.location" Column | Type | Modifiers -------------+------------------------+----------- countrycode | character varying(2) | postalcode | character varying(20) | place | character varying(100) | state | character varying(20) | country | character varying(100) | country2 | character varying(20) | community | character varying(100) | community2 | character varying(20) | latitude | double precision | longitude | double precision | accuracy | integer | </code></pre> how to solve this? Input: <pre><code>AD AD100 Canillo 42.5833 1.6667 6 AD AD200 Encamp 42.5333 1.6333 6 AD AD300 Ordino 42.6 1.55 6 AD AD400 La Massana 42.5667 1.4833 6 AD AD500 Andorra la Vella 42.5 1.5 6 AD AD600 Sant Julià de Lòria 42.4667 1.5 6 AD AD700 Escaldes-Engordany 42.5 1.5667 6 AR 3636 "POZO CERCADO (EL CHORRO (F), DPTO. RIVADAVIA (S))" SALTA A -23.4933 -61.9267 3 AR 4123 LAS SALADAS SALTA A -25.7833 -64.5 4 AR 4126 LA MARAVILLA SALTA A -26.0833 -65.263 3 AR 4126 TALA SALTA A -26.1167 -65.2833 4 AR 4126 LA ASUNCION SALTA A -26.0833 -65.263 3 AR 4126 BRETE SALTA A -26.0667 -65.3667 4 AR 4126 EL SUNCHAL SALTA A -26.0833 -65.263 3 AR 4126 CEIBAL SALTA A -26.1 -65.0167 4 AR 4126 BARADERO SALTA A -26.0833 -65.263 3 AR 4126 CANDELARIA SALTA A -26.1 -65.1 4 AR 4126 ALEM SALTA A -26.0833 -65.263 3 AR 4126 EL BRETE SALTA A -26.0667 -65.3667 4 AR 4126 EL CUIBAL SALTA A -26.0833 -65.263 3 AR 4126 EL JARDIN SALTA A -26.0833 -65.3833 4 AR 4126 OVEJERO SALTA A -26.0833 -65.263 3 AR 4126 LOS MOGOTES SALTA A -26.0333 -65.2 4 AR 4126 "MIRAFLORES (TALA, DPTO. CANDELARIA)" SALTA A -26.0833 -65.263 3 </code></pre> This is some eg for input... when i open this file in ms xcel sheet, with delimiter tab , it seperates the data correctly to the relevent coloumn.. input files with tab and null values, <pre><code>AD\tAD100\tCanillo\t\n\t\n\t\n\t\n\t\n\t\n\t42.5833\t1.6667\t6 AD\tAD200\tEncamp\t\n\t\n\t\n\t\n\t\n\t\n\t42.5333\t1.6333\t6 AR\t3636\t"POZO CERCADO (EL CHORRO (F), DPTO. RIVADAVIA (S))"\tSALTA\tA\t\n\t\n\t\n\t\n\t-23.4933\t-61.9267\t3 </code></pre>
Tags
<postgresql><csv><delimiter>
Title
Import csv file into psql db
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSangeetha Narayana Moorthy
UserOwnerUserId
1. USSangeetha Narayana Moorthy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.