Re: What text format is this and can I import it into Postgres?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: What text format is this and can I import it into Postgres?
Date: 2012-08-23 03:01:35
Message-ID: 50359D0F.8090103@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/22/12 7:17 PM, Mike Christensen wrote:
> This is exactly what I needed. Thanks so much.. Already got the
> first table imported..

I think would use 'TEXT' for the string fields, INTEGER for the whole
numbers and NUMERIC for the fractional ones...
once you have the data imported, and define the appropriate field of
each table as its PRIMARY KEY, you should be able to do a wide range of
joins to collect specific sorts of data.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-08-23 03:16:52 Re: Alternatives to very large tables with many performance-killing indicies?
Previous Message Adrian Klaver 2012-08-23 02:44:39 Re: What text format is this and can I import it into Postgres?