From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | teknokrat <teknokrat(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Quotation marks in queries |
Date: | 2005-07-20 15:47:52 |
Message-ID: | 42DE7228.1000208@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
That's a really good point about the create table, you can actually just
rename everything in you create table statements before you actually do
any data
import, then as long as the fields are in the same physical order(does
not matter if the names are different) you can output data from the
source system as tab delimited and then use the
postgresql copy command to import the tab delimited file to postgresql.
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
>
>So, if you don't use quotes in the CREATE TABLE statement, you'll never
>have to quote anywhere else either...
>
>Have this helps,
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-07-20 16:09:12 | Re: Wishlist? |
Previous Message | Bruno Wolff III | 2005-07-20 15:40:47 | Re: Custom DateStyle |