Skip site navigation (1) Skip section navigation (2)

Re: Importing a CSV file to a table on Postgres

From: "Oliveiros Cristina" <oliveiros(dot)cristina(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: phillip(dot)smith(at)weatherbeeta(dot)com(dot)au, pgsql-novice(at)postgresql(dot)org
Subject: Re: Importing a CSV file to a table on Postgres
Date: 2007-05-06 11:56:03
Message-ID: f54607780705060456w7d658313laab86dea53efd086@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello, Tom,

Thank you for your email

 Yes, what you say makes all sense, but I am not 100% sure if the program
looks exactly as I wrote, I did it by memory. Anyway, I'll check it out
tomorrow at office with my colleague and if more doubts arise, I'll get back
to list.

Thank you for your prompt reply

Best,
Oliveiros


2007/5/5, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> "Oliveiros Cristina" <oliveiros(dot)cristina(at)gmail(dot)com> writes:
> > Suppose I have a row on this table e.g.
> > 120120 ....... www.record.pt\
>
> > If , on PgAdmin, I query
> > SELECT IDSite
> > FROM t_sites
> > WHERE "tName"='www.record.pt\\\\'
>
> > I get nothing, as expected, because the string has two final
> backslashes,
> > not one, as the record on table.
>
> > But if I try to do it on C# it returns me the 120120. (??) It shouldn't
> > return nothing as well.
> > The program is as follows :
>
> > strSite = "www.record.pt\\\\"
>
> I don't know C# well, but if it's at all like C then the string that
> is represented by this literal has only two backslashes, and when it
> gets to the backend that reduces to one backslash, so it matches.
>
>                         regards, tom lane
>

In response to

pgsql-novice by date

Next:From: Jim NasbyDate: 2007-05-06 15:23:24
Subject: Re: including limited lines depending on input parameter
Previous:From: Tom LaneDate: 2007-05-06 00:34:42
Subject: Re: Importing a CSV file to a table on Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group