Thread: Importing dbf files to postgresql

Could someone recommend any utilities for browsing and editing dbf files for
importing to postgresql that will run in linux?  I have data to import, but
it contains some illegal values that need to be cleaned up.

Thanks
John Dougherty

You'll probably just write a scriptlet to filter the data for pgsql's
consumption.

Joshua b. Jore ; http://www.greentechnologist.org

On Sat, 6 Jul 2002, John Dougherty wrote:

> Could someone recommend any utilities for browsing and editing dbf files for
> importing to postgresql that will run in linux?  I have data to import, but
> it contains some illegal values that need to be cleaned up.
>
> Thanks
> John Dougherty
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
>

I am looking for the correct way to retrieve the last 25 records from a dataset without having to first retrieve the
entiredataset to pull out the last 25. 

The potential dataset can be very large... 10,000 records that match the query... yet I only can use the most recent
25.

my first idea is:

SELECT *
FROM table
WHERE thisField=thatValue etc...
ORDER BY table_id DESC
LIMIT 25

But I'm not confident in this and looking for a yeah or nay from a guru or two or three.

Thanks,
Brian

I'm not a guru, but I have used a similar query successfully.

On 2002.07.06 23:48 Brian Scandale wrote:
> I am looking for the correct way to retrieve the last 25 records from
> a dataset without having to first retrieve the entire dataset to pull
> out the last 25.
>
> The potential dataset can be very large... 10,000 records that match
> the query... yet I only can use the most recent 25.
>
> my first idea is:
>
> SELECT *
> FROM table
> WHERE thisField=thatValue etc...
> ORDER BY table_id DESC
> LIMIT 25
>
> But I'm not confident in this and looking for a yeah or nay from a
> guru or two or three.
>
> Thanks,
> Brian
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>

The same we do it for our client who used to upload DBF files and we convert
the same into PostgreSQL table.

If you wish i can send you the Binary file which will convert the DBF into
SQL table (executable on Linux)

Thanx

Denis


----- Original Message -----
From: "John Dougherty" <jwd@softcom.net>
To: <pgsql-novice@postgresql.org>
Sent: Saturday, July 06, 2002 11:27 PM
Subject: [NOVICE] Importing dbf files to postgresql


> Could someone recommend any utilities for browsing and editing dbf files
for
> importing to postgresql that will run in linux?  I have data to import,
but
> it contains some illegal values that need to be cleaned up.
>
> Thanks
> John Dougherty
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Want to retrieve last 25 (recently) inserted records.. use

Order by OID DESC limit 25

Denis


----- Original Message -----
From: "Brian Scandale" <Brrrian@Excite.com>
To: <pgsql-novice@postgresql.org>
Sent: Sunday, July 07, 2002 5:18 AM
Subject: [NOVICE] last 25 records from a dataset


> I am looking for the correct way to retrieve the last 25 records from a
dataset without having to first retrieve the entire dataset to pull out the
last 25.
>
> The potential dataset can be very large... 10,000 records that match the
query... yet I only can use the most recent 25.
>
> my first idea is:
>
> SELECT *
> FROM table
> WHERE thisField=thatValue etc...
> ORDER BY table_id DESC
> LIMIT 25
>
> But I'm not confident in this and looking for a yeah or nay from a guru or
two or three.
>
> Thanks,
> Brian
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster