Contents

1 distinct on

2 Run external script in psql

3 link

--title별 가장 큰 customer_id와 fname 조회
select distinct on (title) title , customer_id, fname
from (select * from customer order by title, customer_id desc) t

psql mydb < dump.sql
psql mydb -f dump.sql

psql -d mydb -f dump.sql

or

psql -f dump.sql mydb


psql [database name] < [script name]

testdb=# \i [script name]

• http://database.sarang.net/?criteria=pgsql
  
• PostgreSQL 8.4: Windowing Functions
  
• http://people.freebsd.org/~kris/scaling/
  
• 벤치마크(postgresql8.3.8 vs sql server 2008 r2