Load Text File into DB

This is what I have used with success..

copy {table name} from '{delimited file name}' using delimiters '\t' with
null as '';

Of course, don't put in the brackets and you can use whatever null character
you might need...

Hope this helps

Chris
Karl J. Stubsjoen wrote in message <9b20s1$1b3d$1@news.tht.net>...

COPY tablename FROM '/home/path/filename';

with the table created with proper columns

Larry Price | "We have seen the truth.
laprice@efn.org | And the truth makes no sense." -chesterton
_______________________________________________________________

On Wed, 11 Apr 2001, Karl J. Stubsjoen wrote:

COPY expects tab delimiters by default, so specifying them is not strictly
necessary in this case.
Specifying "null as xxx" is a good idea, because COPY interprets an empty
field as an empty string, which will cause failure for non text-type fields.
A couple of other things to watch out for when bulk-loading data with COPY
(based on my painful experiences):
* Embedded delimiters, i.e. tabs in your data. Start by grepping for
lines with more than the expected number of tabs.
* Fields ending with a backslash. Sounds unlikely, but this has
happened to me several times. The result is that your delimiter is escaped,
shifting all of your following fields down by one. This will either cause
COPY to fail (because of data type mismatches), or messed up data in that
record.
* For files imported from a Windows machine, better edit out the
carriage returns.