syntax for copy command

hai everybody,
I need to copy data from a text file to a table i used copy command
like this

Expand|Select|Wrap|Line Numbers

copy city from 'e\ccccc.txt' with delimiter as ','

it worked successfully. But now i need to copy a data from a text file which is in my system to the database in server..

path of the file in my system is

Expand|Select|Wrap|Line Numbers

\\ttcpl2\e\ccccc.txt

if use copy command like this

Expand|Select|Wrap|Line Numbers

copy city from '\\Ttcpl2\e\ccccc.txt' with delimiter as ','

I got an error

Expand|Select|Wrap|Line Numbers

 
WARNING:  nonstandard use of \\ in a string literal

LINE 1: copy city from '\\Ttcpl2\e\ccccc.txt' with delimiter as ','

                       ^

HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
 
ERROR: could not open file "\Ttcpl2eccccc.txt" for reading: No such file or directory

SQL state: 58P01

If i use /copy command

Expand|Select|Wrap|Line Numbers

\COPY city FROM '\\ttcpl2\e\ccccc.txt ' WITH DELIMITER ','

Expand|Select|Wrap|Line Numbers

 
ERROR: syntax error at or near "\"

SQL state: 42601

Character: 1

Please help me as soon as possible..........

Aug 14 '07 #1

Subscribe Post Reply

12150

michaelb

534

Expert 512MB

Try either to double the backslashes (use \\\\ instead of \\) or replace them with forward-slashes, that is use "/" in place of "\"

Aug 14 '07 #2

priyan

hai everybody,
I need to copy data from a text file to a table i used copy command
like this

Expand|Select|Wrap|Line Numbers

copy city from 'e\ccccc.txt' with delimiter as ','

it worked successfully. But now i need to copy a data from a text file which is in my system to the database in server..

path of the file in my system is

Expand|Select|Wrap|Line Numbers

\\ttcpl2\e\ccccc.txt

if use copy command like this

Expand|Select|Wrap|Line Numbers

copy city from '\\Ttcpl2\e\ccccc.txt' with delimiter as ','

I got an error

Expand|Select|Wrap|Line Numbers

WARNING:  nonstandard use of \\ in a string literal

LINE 1: copy city from '\\Ttcpl2\e\ccccc.txt' with delimiter as ','

                       ^

HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

ERROR: could not open file "\Ttcpl2eccccc.txt" for reading: No such file or directory

SQL state: 58P01

If i use /copy command

Expand|Select|Wrap|Line Numbers

\COPY city FROM '\\ttcpl2\e\ccccc.txt '  WITH DELIMITER  ','

Expand|Select|Wrap|Line Numbers

ERROR: syntax error at or near "\"

SQL state: 42601

Character: 1

Please help me as soon as possible..........

i have did as if u have said

Expand|Select|Wrap|Line Numbers

\COPY city FROM '//ttcpl2/e/ccccc.txt ' WITH DELIMITER ',';

Expand|Select|Wrap|Line Numbers

 
ERROR: syntax error at or near "\"

SQL state: 42601

Character: 1

Aug 15 '07 #3

michaelb

534

Expert 512MB

i have did as if u have said

Expand|Select|Wrap|Line Numbers

\COPY city FROM '//ttcpl2/e/ccccc.txt ' WITH DELIMITER ',';

Expand|Select|Wrap|Line Numbers

ERROR: syntax error at or near "\"

SQL state: 42601

Character: 1

Why do you have a backslash at the beginning of your command?

Aug 15 '07 #4

by: Sarah | last post by:

Hi! I have perhaps a strange question... I have a javascript that activates on a right click and shows the user a little menu of links. However, by doing so, it disables the users ability to...

Javascript

copy command problem

by: Don Isgitt | last post by:

Hi, I am recreating a database and its applications onto a new server and new software; old version of pg was 7.2.4 and new version is gds2=# select version(); version ...

PostgreSQL Database

simulate copy command

by: J M | last post by:

How do I run following from csharp from "server"? copy file.txt \\server\printer1 Also how can I submit a text file print job to local print queue "printer1"? Assuming I run copy command from...

C# / C Sharp

copy command verbose

by: Bob Powell | last post by:

To whom it may concern: Does anyone know if it is possible to make the COPY command in postgres verbose. It would be very helpful if an error would generate when something goes wrong with a...

PostgreSQL Database

Problem with sql COPY command

by: Jon Asher | last post by:

Hi, I'm trying to do a simple import of a comma delimited text file with COPY but it's returning an error. The file has been granted all permissions in Linux, so it's not clear to me what the...

PostgreSQL Database

COPY command with PHP

by: Robert Fitzpatrick | last post by:

I have a PHP script that was having problems using the COPY command with files around 1500 lines in size. The script will build the copy data from incoming CSV file into a temp file, then start a...

PostgreSQL Database

copy command using system

by: devinath | last post by:

I came across a problem while running the system file. When the copy command is run using system command , it doesn’t copy files which have size of 0kb. But the same command works if run thru the...

Microsoft Windows

copy command

by: coolminded | last post by:

can we use the copy command to copy it in the local disk copy temp_swap TO ''c:\folder_name\";

PostgreSQL Database

COPY command error

by: ibo3 | last post by:

I used the copy command as stateed below, to copy a file containing data, which I want to load into my evaluations table. I get the following error, can some one explain to me what I may be doing...

PostgreSQL Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics