Re: Table column headings PgAmin4

Hi Murtuza Thank you for your reply. Unfortunately it is not practical to use this approach when there may be 100s of columns! I will look at pgfutter. regards Ted Jones - Original Message - From: Murtuza Zabuawala To: TedJones Cc: pgAdmin Support Sent: Wednesday,

Re: Table column headings PgAmin4

On Wed, Feb 7, 2018 at 11:01 AM, Ted Jones wrote: > Hi Murtuza > > Thank you for your reply. Unfortunately it is not practical to use this > approach when there may be 100s of columns! I will look at pgfutter. > ​When faced with this situation, and feeling unmotivated to go

Re: Table column headings PgAmin4

On Wed, Feb 7, 2018 at 11:47 AM, Ted Jones 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]

Re: Table column headings PgAmin4

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

Re: Table column headings PgAmin4

On Wed, Feb 7, 2018 at 1:00 PM, Strauch, Sheldon 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:

password

Hi, I forgot my password and unable to find reset option. If you can help Thanks Riya

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

Re: password

Password of pgAdmin4 or PostgreSQL? -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Feb 7, 2018 at 12:26 PM, Riya Solanki wrote: > Hi, > I forgot my password and unable to find reset option. If you can

Re: able column headings PgAmin4

On Wed, Feb 07, 2018 at 01:59:32PM -0800, Anthony DeBarros wrote: > 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/ For the same purpose I have written a script in Julia which I regularly use. It creates

Table column headings PgAmin4

I am quite new to PostgreSQL and I am having difficulty with the following: I am trying to input a csv file into a table that has a very large number of columns. This means that it is impractical to create a table and specify the name of all the columns. Can the column headings be taken from the

Re: Table column headings PgAmin4

First, please note that PgAdmin4 is just an interface to PostgreSQL, so it is very helpful if you state the actual version of PostgreSQL and O/S you are working with.IE: SELECT version(); >Can the column headings be taken from the first line of the csv file? Yes. >Additionally, I have tried