Skip site navigation (1) Skip section navigation (2)

Re: Fwd: PostgreSQL questions - copy / paste new data and updating records

From: Jon Erdman <jon(at)progressivepractice(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Alex Marinov <alex(at)tennisround(dot)com>, austinpug(at)postgresql(dot)org
Subject: Re: Fwd: PostgreSQL questions - copy / paste new data and updating records
Date: 2011-09-26 19:50:11
Message-ID: 4E80D773.50203@progressivepractice.com (view raw or flat)
Thread:
Lists: austinpug
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Another possible option might be the PG ODBC driver. IIRC excel can use
and ODBC connector to a database, but I've never actually done it.
Merlin's suggestion is probably the easiest.

As far as "looking up records", are you asking how to query a table in
postgres?

- --

Jon T Erdman

Chief Information Officer            voice:       (312) 285-6735
Progressive Practice, Inc.           jon(at)progressivepractice(dot)com
P.O. Box 17288                       www.progressivepractice.com
Rochester, NY 14617

On 09/26/2011 08:32 AM, Merlin Moncure wrote:
> On Sun, Sep 25, 2011 at 8:27 PM, Alex Marinov <alex(at)tennisround(dot)com> wrote:
>> Hi,
>>
>> My name is Alex and I'm part of a small team working on
>> http://www.tennisround.com/ - a tennis directory and scheduling platform.
>>
>> I'm looking for help with a couple of things - 1) importing data from Excel
>> into Postgresql on an ad-hoc basis - copy / paste style or through the
>> PgAdmin UI and 2) looking up specific records (CTRL+F style or search by
>> keyword).
> 
> The best way to import data from excel is going to be programatically.
>  What I typically do is save the excel sheet as a csv delimited text
> file and import it to a staging table with postgres's built in 'copy'
> (which has a csv switch).  The copy command can be invoked from
> pgadmin or through psql via a script.  By staging table I mean a
> specially designated table that contains all text fields for the
> import data.  From there, you can move the data to proper tables with
> queries.
> 
> merlin
> 
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6A13MACgkQRAk1+p0GhSGk/wCfZTGvflcTCuQyBz4RMf4oEVAA
ju4AnjxKXlbSYE1QaTx+f9J0YUgiFmM1
=+Zqh
-----END PGP SIGNATURE-----

In response to

Responses

austinpug by date

Next:From: Alex Marinov TRDate: 2011-09-26 20:03:28
Subject: Re: Fwd: PostgreSQL questions - copy / paste new data and updating records
Previous:From: Merlin MoncureDate: 2011-09-26 13:32:59
Subject: Re: Fwd: PostgreSQL questions - copy / paste new data and updating records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group