C#

<br />
String strMovName;<br />
strMovName = dlgFile.FileName;<br />
NpgsqlConnection conn = new NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=postgres;Password=secret;Database=db;");<br />
<br />
//Get the full pathname of the file<br />
            FileInfo TheFileName = new FileInfo(strMovName);<br />
            //Open a connection and chuck the stuff in<br />
            conn.Open();<br />
            NpgsqlCommand command = new NpgsqlCommand("INSERT INTO resources (object) VALUES (lo_import('C:/Program Files/Movies/" + TheFileName.Name + "'))", conn);<br />
            command.ExecuteNonQuery();<br />
            conn.Close();<br />

Farica wrote:

# Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.

private string insertChars(string str, char insertChar, int[] insertIndexes)
{
    StringBuilder b = new StringBuilder(str.Length + insertIndexes.Length);
    int count = 0;

    for (int i = 0; i != str.Length;i++)
    {
        if (i == insertIndexes[count])
        {
            b.Append(insertChar);

            if (++count==insertIndexes.Length)
            {
                b.Append(str.Substring(i,str.Length-i));
                break;
            }
        }

        b.Append(str[i]);
    }

    return b.ToString();
}

string oneSpace = " ";
string twoSpaces = "  ";
string str = "You  left out       any  multiple    spaces in your            example";
string newStr = str.Replace(twoSpaces,oneSpace);

string s="whatever with many spaces";
do {
    int len=s.Length;
    s=s.Replace(twoSpaces, oneSpace);
} while (s.Length<len);

string test = "this  string   has    multiple    spaces      .";
StringBuilder sb = new StringBuilder(test);
int l1 = sb.Length;
int l2 = l1 +1;
while (l1 != l2)
{
    l1 = sb.Length;
    sb.Replace("  ", " ");
    l2 = sb.Length;
}
string result = sb.ToString();