On 24 Mar 2014, at 5:32, Rajeev rastogi wrote:
> On 21st March 2014, Ashmita Jain Wrote:
>
> >It is taking date as an empty string.
> >Try defining the empty field as ‘\N’ in your source file.
>
> ‘\N’ in copy source file always results into an empty string (unless
> something written in ne
On 21st March 2014, Ashmita Jain Wrote:
>It is taking date as an empty string.
>Try defining the empty field as '\N' in your source file.
'\N' in copy source file always results into an empty string (unless something
written in new line), which is correct only.
So COPY from such source file will
paulo matadr wrote:
> When I try to import big file base.txt( 700MB),I get this:
>
> x=# create table arquivo_serasa_marco( varchar(3000));
> x=# COPY arquivo_serasa_marco from
> '/usr/local/pgsql/data/base.txt';
> ERROR: literal newline found in data
> HINT: Use "\n" to represent newli
Bill Todd <[EMAIL PROTECTED]> writes:
> I am beginning to suspect this is impossible.
That's correct: see the COPY reference page. A quoted value is never
considered to match the NULL string.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Joshua D. Drake wrote:
On Fri, 2008-12-05 at 12:00 -0700, Bill Todd wrote:
Joshua D. Drake wrote:
On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
null as IS NULL results in the following error.
ERROR: syntax error at or near "is"
LINE 5: null as is null
On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
> Using 8.3.3 I am trying to import a CSV file using the following copy
> command.
>
> copy billing.contact from 'c:/export/contact.csv'
> with delimiter as ','
> null as ''
> csv quote as '"';
>
> The following record record causes an error be
On Mon, Jun 04, 2007 at 02:12:00PM -0400, ABHANG RANE wrote:
> Im trying to load data from a file using copy command. At the end of
> the data, I have appended copy statement as
>
> copy tablename(col1, col2) from stdin with delimiter as '\t';
> .\
COPY should go before the data and end-of-data
Bruno Wolff III wrote:
On Fri, Jun 04, 2004 at 14:11:19 +,
Bricklen <[EMAIL PROTECTED]> wrote:
Hi, I'm not sure if this is the correct group for this question, but
I'll post it hoping that it is.
I'm loading several ~15 million row files into a table using the COPY
command. Apparently one o
Give the fullname of the file. Make sure the file is on the server machine and not
your local machine (in case you are forwarding pgaccess to another X terminal)
cheers,
thalis
On 16 Jun 2001, Chakravarthy K Sannedhi wrote:
> Hi,
>
> When I am trying to import a file in my home directory int
Lee Joramo <[EMAIL PROTECTED]> writes:
> [PostgreSQL 6.5.2 on powerpc-unknown-linux-gnu, compiled by gcc 2.95.2]
Hm. Did you compile at -O0? Pre-7.1 PG is known to have a lot of
problems on PPC if compiled with any optimization at all.
> The 'classifieds.dat' consists of about 2200 lines. I ha
10 matches
Mail list logo
