Re: command line v GUI and COPY

for GUI, do you have pgadmin installed?

For the 'extra data after the last column'

The error should have given you a row number. Did you open up the file and
that row number and make sure there wasn't?

On Tue, Oct 14, 2014 at 12:35 PM, John Polo <polo(at)okstate(dot)edu> wrote:

> Greetings,
> I have looked through the documentation provided on postgresql.org for
> help with a few items, since I don't know much about DBs or PostgreSQL. It
> seems that most of the documentation on the site is focused toward on the
> command line. Is there another useful resource that focuses on GUI help?
>
> At the moment I have several CSVs from the US Forest Service's FIA progam
> and would like to set up a new DB with the CSVs as tables. I set up a
> non-admin user and when I try to import a CSV to a table, I get a couple of
> error messages. The first is that there is extra data after the last
> column. I read somewhere that error arose because I was importing to an
> existing table, even though the table was something I just made in GUI by
> right-clicking and using the menu and the table as far as I knew was empty.
> I deleted the table and am trying to find another way to create a table by
> clicking on something and copying directly/importing from the CSV.
>
> I tried psql. I wrote "create table ok_boundary;
> copy ok_boundary from 'c:\[...]ok_boundary.csv' delimiter ',' csv header;"
> (all with caps as shown in documentation or on stackoverflow.com) and it
> wouldn't let me create the table to begin with. Trying to pick up the
> command line stuff is slower than the GUI for me, so it would be great if I
> could find something to get through the initial steps that is less focused
> on the command line. In the bigger picture, I am trying to get PostgreSQL
> and PostGIS to work with QGIS for a couple of GIS projects and so in the
> process, I am trying to get my head wrapped around those two former
> programs and their connections.
>
> John Polo
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>