Skip to main content

Return to Question

added 1 character in body
Source Link
junior
junior
  • 123
  • 1
  • 1
  • 6

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\\temp\\\city\\temp\\city.csv'
------//////////////------copy(select * from city) to E'C:\\\temp\\\city\\temp\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\\temp\\\city.csv'
------//////////////------ E'C:\\\temp\\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\temp\\city.csv'
copy(select * from city) to E'C:\\temp\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

formatting
Source Link
junior
junior
  • 123
  • 1
  • 1
  • 6

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\\temp\\\city.csv'
------//////////////------ E'C:\\\temp\\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\\temp\\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\\temp\\\city.csv'
------//////////////------ E'C:\\\temp\\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

formatting
Source Link
edit approved May 8, 2015 at 18:39
OhBeWise
edit approved May 8, 2015 at 18:39
OhBeWise
  • 5.4k
  • 5
  • 34
  • 62

I use PostgreSQL 9.4.1

My query: copy(select * from city) to 'C:\\temp\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

copy(select * from city) to 'C:\\\temp\\\city.csv'

ERROR: relative path not allowed for COPY to file SQL state: 42602

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

I use PostgreSQL 9.4.1

My query: copy(select * from city) to 'C:\\temp\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\\temp\\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

Source Link
junior
junior
  • 123
  • 1
  • 1
  • 6