Re: BUG #14214: i am enable to upload .xlsx file in my postgres database. - Mailing list pgsql-bugs

From John McKown
Subject Re: BUG #14214: i am enable to upload .xlsx file in my postgres database.
Date
Msg-id CAAJSdjh4WBtvCi+_Gk69=oFcx-=P6F-uyroZAGiV0T2c3gMq=w@mail.gmail.com
Whole thread Raw
In response to BUG #14214: i am enable to upload .xlsx file in my postgres database.  (zzia88@gmail.com)
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #14214: i am enable to upload .xlsx file in my postgres database.
Next
From: Robert Haas
Date:
Subject: Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column