Re: Table column headings PgAmin4

Hi, all,

My favorite solution to this issue is to use the very handy Python library
csvkit: https://csvkit.readthedocs.io/en/1.0.2/

It includes the command line utility csvsql (
https://csvkit.readthedocs.io/en/1.0.2/scripts/csvsql.html) which will
read a CSV and generate a CREATE TABLE statement. It does a fairly good job
of inferring data types from the column values in the CSV.

It works with PostgreSQL and other DBs as well.

Best,
Anthony DeBarros

On February 7, 2018 at 3:07:21 PM, Strauch, Sheldon (sstrauch(at)enova(dot)com)
wrote:

Ted and David,

Howdy! I too desperately crave this feature in pgAdmin. In light of the
fact that there are now three of us interested in this, I have created the
feature request in RedMine: https://redmine.postgresql.org/issues/3092

Hopefully, this helps the cause...

On Wed, Feb 7, 2018 at 12:53 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wed, Feb 7, 2018 at 11:47 AM, Ted Jones <ted(at)mentra(dot)co(dot)uk> wrote:
>
>> Hi David
>>
>> I'm sorry but I'm not sure what you mean! Can you give me a simple
>> example? Thanks.
>>
>>
> ​Something like in the attached image.​
>
> [image: Inline image 1]
>

--

Assumptions validated by consistent data from actual experiments enable the
creation of real value.

Sheldon E. Strauch
*Data Architect, Data Services *
*O* 312-676-1556
*M* 224-723-3878

*Enova International, Inc.*
*This transmission is confidential and may be privileged or proprietary. If
you are not the intended recipient, you are not authorized to use the
information in this transmission in any way. Please inform the sender
immediately if you have received this transmission in error and permanently
delete and destroy the original and any copies of the information.*