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

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

From: Alex Marinov TR <alex(at)tennisround(dot)com>
To: Jon Erdman <jon(at)progressivepractice(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, "austinpug(at)postgresql(dot)org" <austinpug(at)postgresql(dot)org>
Subject: Re: Fwd: PostgreSQL questions - copy / paste new data and updating records
Date: 2011-09-26 20:03:28
Message-ID: 46355529-A0F0-4E78-B5E7-C5F4392CFBDD@tennisround.com (view raw or flat)
Thread:
Lists: austinpug

On Sep 26, 2011, at 12:50 PM, Jon Erdman <jon(at)progressivepractice(dot)com> wrote:

> -----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

We have about 20,000 records of tennis facilities. Sometimes people call in with updates - new phone, new address, more courts, etc. To my surprise I couldn't figure out a way to look up Heather Farm Park, Walnut Creek, CA when I opened the table of records in pgAdmin. So I don't know how to find that listing to change its phone.

Thanks,
Alex


> 
> 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: Neal BrownDate: 2011-09-26 20:43:23
Subject: Re: Fwd: PostgreSQL questions - copy / paste new data and updating records
Previous:From: Jon ErdmanDate: 2011-09-26 19:50:11
Subject: Re: Fwd: PostgreSQL questions - copy / paste new data and updating records

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