Postgresに初期データを投入

１．Linuxユーザの作成
postgresで設定したユーザをLinuxユーザとしても追加する必要があります。
これをしないとCOPYが実行できません。

adduser postgresusr

２．CSVファイルの配置
WinSCPを使用してCSVファイルをアップロード
所定のフォルダにCSVファイルを配置する。

３．CSVファイルへの権限付与
CSVファイルに権限付与を実施。
chmod -R 777 /home/linux/data
（全権限付与でなくても実行可能なはず）

４．Postgresにログイン
psql -h localhost -U postgresusr -d postgresdb

３．COPYコマンド実行
COPY TEST FROM '/home/linux/data/test.csv' WITH CSV;

４．SQLファイル実行
\i /home/linux/data/template.sql

○参考サイト
http://www.dbonline.jp/postgresql/connect/index2.html
http://okwave.jp/qa/q6807324.html
http://itpro.nikkeibp.co.jp/article/COLUMN/20060227/230728/
http://homepage3.nifty.com/nasunu-i/LinuxBeginner/Permission.htm
http://sasuke.main.jp/postgrescmd.html

Comments

How to deploy your PHP and Java file in PHP/JavaBridge

Here I explain how to deploy your PHP and Java file in your PHP/JavaBridge folder. You may need basic knowledge of Linux command, PHP , Java , Tomcat . Please use the link below to go to further reading if necessary. I. How to install Java II. How to install Tomcat III. How to install PHP and CGI IV. How to deploy PHP/JavaBridge V. How to deploy your PHP and Java files V. Deploy your PHP and Java file In this chapter, I will not talk detail about how to create and run Java . If you are curious about how to create PHP that executes Java , check PHP/JavaBridge site. 1. Create Java Hello World 1.1. Open eclipse and create Java Project . 1.2. Create HelloWorld.java file under the project. import javax.swing.JOptionPane; public class HelloWorld { public static final String JAVABRIDGE_PORT="8080"; static final php.java.bridge.JavaBridgeRunner runner = php.java.bridge.JavaBridgeRunner.getInstance(JAVABRIDGE_PORT); public stat...

How to install PHP and CGI on your Mac 

Here I explain how to install PHP and CGI on your . You may need basic knowledge of Linux command, PHP , Java , Tomcat . Please use the link below to go to further reading if necessary. I. How to install Java II. How to install Tomcat III. How to install PHP and CGI IV. How to deploy PHP/JavaBridge V. How to deploy your PHP and Java files III. How to install PHP and CGI 1. Check PHP and CGI are installed 1.1. Check PHP version Open Terminal and enter following command. php -v You can also find out where is php.ini by entering these following command. which php whereis php 1.2. Check CGI version php-cgi If you see your result as below, you have already installed PHP and CGI. If not, follow next step. 2. Install XCode In order to use Port , you need to install XCode first. Open AppStore and install XCode . Make sure you run XCode after the installation. 3. Install Port Here I show How to install Port . If you have Brew , go head and use it instead of P...

How to deploy PHP/JavaBridge on your Mac 

Here I explain how to deploy PHP/JavaBridge on your . You may need basic knowledge of Linux command, PHP , Java , Tomcat . Please use the link below to go to further reading if necessary. I. How to install Java II. How to install Tomcat III. How to install PHP and CGI IV. How to deploy PHP/JavaBridge V. How to deploy your PHP and Java files IV. Deploy PHP/JavaBridge 1. Download JavaBridge Download JavaBridge.war from PHP/JavaBridge site . 2. Deploy war file Move the war file to /usr/local/{your tomcat version folder}/webapps/ After few seconds, JavaBridge folder will be created. 3. Change PHP configration 3.1. Go to PHP folder Open Finder and go to directory showed on the test page. 3.2. Edit php.ini file php.ini file and add following line. allow_url_include = On 4. Restart Tomcat If you have not set up Tomcat on your local machine, here is II. How to install Tomcat . /Library/Tomcat/bin/startup.sh /Library/Tomcat/bin/shutdown.sh 5. Check JavaBridge G...

Infinity by exponent

Search This Blog