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

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