Re: BUG #14214: i am enable to upload .xlsx file in my postgres database.

Поиск
Список
Период
Сортировка
От John McKown
Тема Re: BUG #14214: i am enable to upload .xlsx file in my postgres database.
Дата
Msg-id CAAJSdjh4WBtvCi+_Gk69=oFcx-=P6F-uyroZAGiV0T2c3gMq=w@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14214: i am enable to upload .xlsx file in my postgres database.  (zzia88@gmail.com)
Список pgsql-bugs
On Fri, Jun 24, 2016 at 12:32 PM, <zzia88@gmail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14214
> Logged by:          Zubair Alam
> Email address:      zzia88@gmail.com
> PostgreSQL version: 9.5.3
> Operating system:   windows7-x64(64 bit)
> Description:
>
> please give solution upload of .xlsx file to postgres, i don't want to
> change my excel file to .csv.
>

=E2=80=8BIf by this, you mean that you want PostgreSQL to be able to direct=
ly read
an Excel xlsx file, that would be a enhancement request, not a bug. I
really think it would be simpler, over all, to just use Excel and do a
"save as" to a different file in CSV format yourself, then import that. I
can understand how this could be "inconvenient", but that happens some
times. Or you could write your own code using Perl, R, Python, or maybe
even one of the MS languages such as C# (I don't know C#).

--=20
"Pessimism is a admirable quality in an engineer. Pessimistic people check
their work three times, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you're mistaking the word optimistic for inept."
"They've got a similar ring to my ear."

From "Star Nomad" by Lindsay Buroker:

Maranatha! <><
John McKown

В списке pgsql-bugs по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: BUG #14214: i am enable to upload .xlsx file in my postgres database.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column