From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Utility that creates table schema from csv data? |
Date: | 2005-09-13 07:12:28 |
Message-ID: | 43267BDC.40300@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
CSN wrote:
> Probably wishful thinking, but who knows - maybe
> there's something in contrib! I have a bunch of csv
> data with the field names specified on the first line
> of the various files. Is there any such utility that
> will create a table schema using the field names AND
> look through the data and determine what data types
> each field should be?
I'm not sure that's possible in a general sense. Is 123 text or a
number? How do I prove it one way or another?
However, if you were happy to end up with "good enough" types (i.e.
might end up using text instead of a more specific type), and know that
data was representative then it shouldn't be too tricky to write some
pattern-matching Perl to do the job.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2005-09-13 10:39:05 | kernel log un upgrade of postgresql-common |
Previous Message | Thomas Pundt | 2005-09-13 07:04:31 | Re: Building postgres on Suze |