From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | e-letter <inpost(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: create database from text file, to delete columns |
Date: | 2008-04-03 15:00:25 |
Message-ID: | 264855a00804030800s3178472t3d23015d771acb45@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, Apr 3, 2008 at 10:43 AM, e-letter <inpost(at)gmail(dot)com> wrote:
> On 03/04/2008, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
> >
> > You will still need to create all the columns for your table first.
> > Also, I think you'll want to look at the documentation for the copy
> > command, as what you give above should probably result in an error.
> >
> So columns cannot be automatically created. The documentation is poor,
> for example the 'explanation' of the use of |stdin should really
> explain that as an alternative
No. Columns are not automatically created. As for documentation,
what you see is the standard way of describing SQL. I agree it can be
confusing in the beginning.
If all you want to do is load data into a database to look at it, you
might look at MS Access or Filemaker. I don't recommend these as
database solutions, but as more of an excel replacement.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Francois Cote | 2008-04-04 19:41:35 | Problem with data storage |
Previous Message | e-letter | 2008-04-03 14:43:01 | Re: create database from text file, to delete columns |