User Profile

Collapse

Profile Sidebar

Collapse
kallem
kallem
Last Activity: Mar 11 '11, 09:30 AM
Joined: Jan 20 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kallem
    started a topic Error when using openrowset for particular record
    in SQL Server

    Error when using openrowset for particular record

    Hi,
    I am executing following query
    [INSERT INTO OPENROWSET('MSD ASQL', 'Driver=Postgre SQL Unicode;uid=pos tgres;Server=lo calhost;port=54 32;database=dat a;pwd=XXXX',
    'SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid
    FROM Project WHERE projectCode = ''-1'' ')
    SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid from...
    See more | Go to post
    • kallem
      replied to How to use Copy Command in a loop?
      in PostgreSQL
      can you give sample script i dont know how to do that
      See more | Go to post

        Leave a comment:

      • kallem
        started a topic copy command in postgresql
        in PostgreSQL

        copy command in postgresql

        Hi kindly correct me the following code
        [CREATE OR REPLACE FUNCTION dataimport()
        RETURNS void AS
        $BODY$
        DECLARE

        t_name RECORD;

        BEGIN
        FOR t_name IN
        SELECT
        c.relname
        FROM
        pg_catalog.pg_c lass c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
        WHERE
        c.relkind = 'r'...
        See more | Go to post
        • kallem
          started a topic sql server generated “Text File” data importing in to postgressql using copy command
          in PostgreSQL

          sql server generated “Text File” data importing in to postgressql using copy command

          Hi

          I have one text file generated using SQLServer 2005. While I am importing the text file into one of my PostgreSQL table using "copy" it is giving me the following error:

          ERROR: invalid byte sequence for encoding "UTF8": 0xff

          Can any one tell me what i need to do get the data from SQLServer 2005 to PostgreSQL?
          See more | Go to post
          • kallem
            started a topic How to use Copy Command in a loop?
            in PostgreSQL

            How to use Copy Command in a loop?

            hi,

            [COPY worktrainees_hi story FROM E'C:\\bcp\\work trainees_histor y.txt' USING DELIMITERS ',' CSV]

            the above command is working fine but i have more than 100 tables and related text files i wanted to run in a loop but
            when i use a parameter for table name it is giving error so can any one give me example for this
            See more | Go to post
            • kallem
              started a topic How to write stored procedure in plpgsql to connect to the sql server 2005?
              in PostgreSQL

              How to write stored procedure in plpgsql to connect to the sql server 2005?

              Hi,

              I just want to create a stored procedure/Function which should address the following features

              1. Able to connect to the SQL Server 2005
              2. fetch the data from tables
              3. inserting into the postgresql database

              Kindly suggest me the way forward or sample procedure
              See more | Go to post
              No activity results to display
              Show More
              Working...