Re: inet/cidr data types
От | Tino Wildenhain |
---|---|
Тема | Re: inet/cidr data types |
Дата | |
Msg-id | 17116111.1036764197@liza обсуждение исходный текст |
Ответ на | inet/cidr data types (Russell Aspinwall <russell.aspinwall@flomerics.co.uk>) |
Список | pgsql-general |
Hi Russel, it might be more easy and faster if you use the copy comand: COPY targettable FROM 'filename' [USING] DELIMITERS 'delimiter' WITH NULL AS '' delimiter depends on your data, either ',' or ';' or '\t' Regards Tino --On Freitag, 8. November 2002 12:18 +0000 Russell Aspinwall <russell.aspinwall@flomerics.co.uk> wrote: > Hi, > > I need to store 2GB of accumulated data into a database. I have built > v7.2.3 with Java, Tcl/Tk, Perl, C++ language extensions. I have written > nawk scripts to convert csv data into the appropiate INSERT INTO > commands, then adding the data is a simple matter of running psql -d > <database> -f date.psql > > Some of the fields are of type inet or cidr , however these fields do > not always contain a value. I need to be able to set the field to null > in my INSERT INTO command the empty values are represented by ''. > However during the INSERT command, the command can fail with a message > like. I would like to be able to queries on these fields but > automatically exclude the null values. > > psql:test.psql:1: ERROR: invalid CIDR value '' > > Any help would be appreciated. > > Russell > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
В списке pgsql-general по дате отправления: