Re: Importing a CSV file to a table on Postgres

Hello, Phillip.
Hello, all.

Thank you for your email, it worked nicely.

Now I have another question not related to this one, and I am not sure if this is the right list or if there is a specialized list.
It has to do with Npgsql, the C# interface to postgres.

I have a table that looks like the following
t_sites(IDSite,......,tName )

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\\\\"

strQuery = "SELECT \"IDSite\" FROM t_sites " + "WHERE \"tName\" = '" + strSite + "'";


cSqlCommand = new NpgsqlCommand(strQuery, m_cConnectionToDb);
try
{
    i_int_rec.IDSite = (int)cSqlCommand.ExecuteScalar();
}//try
catch
{
/* This code is not executed */
}//catch

i.e. the ExecuteScalar() Method returns one key, the www.record.pt\ one, 120120, but it should return null, because the result should be empty. www.record.pt\ != www.record.pt\\  , is that not true?
Does the ExecuteScalar() method remove additional backslashes or kinda?

Actually I did on C# a small test program that issues the
SELECT IDSite,tName
FROM t_sites
query against my postgres database and then lists the results on screen, and the fact is that www.record.pt\\ does not appear which is correct.
Still, ExecuteScalar() behaves as the record was there and returns the primary key of ...the www.record.pt\ which is not the right one!

Can anyone please kindly indicate what am I doing wrong on the program?

Any help/advice deeply appreciated

Warm Regards,
Oliveiros

Lisboa,
Portugal