Re: all useful options disabled in the Import dialog - Mailing list pgadmin-support

From Leonard Boyce
Subject Re: all useful options disabled in the Import dialog
Date
Msg-id CAKj1m=Kv3T5rKbiGcTTxPj589TK52weMHKxvxBpmSZUxeFAfjQ@mail.gmail.com
Whole thread Raw
In response to all useful options disabled in the Import dialog  (Joe Strout <joe@luminaryapps.com>)
Responses Re: all useful options disabled in the Import dialog  (Joe Strout <joe@luminaryapps.com>)
List pgadmin-support
Hi Joe,

Did you select 'csv' as the format in 'File Options'? If 'text' is
selected the options you're referring to are disabled it seems.

Leonard

On Fri, Jan 9, 2015 at 11:17 AM, Joe Strout <joe@luminaryapps.com> wrote:
> I'm trying to import a CSV file on my local machine, to a pgsql database
> running on a server.  I'm running pgAdmin III 1.18.1.
>
> This is a standard CSV file with a header line, and quotes around any values
> that happen to contain commas.
>
> Problem is, all the useful options in the Import dialog are disabled. This
> includes the Header checkbox on the Misc. Options tab, and both Quote and
> Escape on the Quote Options tab.
>
> Without being able to set these options, of course, the import fails. I've
> searched the internets and any documentation I can find (which isn't much),
> but can't figure out why these options or disabled or how to fix it.
>
> Any ideas?
>
> Thanks,
> - Joe
>
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support



pgadmin-support by date:

Previous
From: Joe Strout
Date:
Subject: all useful options disabled in the Import dialog
Next
From: Joe Strout
Date:
Subject: Re: all useful options disabled in the Import dialog