ERROR: must be superuser to COPY to or from a file
来源:互联网 发布:茄子换机软件 编辑:程序博客网 时间:2024/05/18 14:13
用COPY需要superuser很麻烦
直接用 \copy就可以把file导入到表中了
> Hello> > I want to fill in a table from a file, but when I use the COPY command I> > get the following error:> >> > mydb=> COPY weather FROM '/home/fideito/weather.txt';> > ERROR: must be superuser to COPY to or from a file> > HINT: Anyone can COPY to stdout or from stdin. psql's \copy command> > also works for anyone.> >> > But, what can I do if I'm not root?
Use \copy (as the error message suggests) rather than copy. That shoulddo it.
0 0
- ERROR: must be superuser to COPY to or from a file
- error : A file found in a source-path must have an externally visible definition. If a definition in the file is meant to be ext
- A value is trying to be set on a copy of a slice from a DataFrame
- How to copy a datafile from ASM to a file system not using RMAN
- ....Fragment must be a public static class to be properly recreated from instance state.
- IllegalStateException: Fragment null must be a public static class to be properly recreated from ins
- cocos2d 安装出现Error: This script must be run as root in order to copy templates to /Library/Applicatio
- cocos2d安装出现Error: This script must be run as root in order to copy templates to /Library/Application
- .Net Program Unable to copy a file from obj\Debug to bin\Debug
- must be caught or declared to be thrown
- VS2010:error C3083: 'Windows': the symbol to the left of a '::' must be a type
- VS2010:error C3083: 'Office': the symbol to the left of a '::' must be a type
- EXP-00023: must be a DBA to do Full Database or Tablespace
- to be A Coder,OR A Programmer
- to be a Programmer or a Architect?
- to be or not to be, that is a question...
- To be or not to be that is a question
- 问题解决:SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame
- POJ 2503 动态建树
- android逆向6
- 关于JVM与DVM,这些你可能不知道
- Arrays.binarySearch(二分法检索)
- 棋子翻转---- 美团2016研发工程师在线编程题
- ERROR: must be superuser to COPY to or from a file
- app审核被拒
- golang 通过gin框架获取未知的参数
- android逆向7
- 用Parcelable接口传递Bitmap
- HDFS inotify:Linux inotify机制在HDFS中的实现
- arm应用程序之文件读写操作差异open与fopen
- 封装
- 将对象转化为XML格式的字符串