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'...
2 results in 0.0013 seconds.
-
copy command in postgresql
-
kallem started a topic sql server generated “Text File” data importing in to postgressql using copy commandin PostgreSQLsql 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?