Re: Quotation marks in queries

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,
>
>

In response to

Browse pgsql-general by date

  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