Pazartesi, Ekim 05, 2009

Postgres degisken

\set degisken 'lalala'

Sadece \set mevcut degiskenleri listeler

select * from tablo where sutun=:degisken;

Tabloyu dosyaya aktar

Either:

SELECT * FROM table \g filename

to just output to the file 'filename', or:

select * from lineshoot \g |cat >> /solsolute/path/filename

to append to the file. Both in psql, or:

echo 'SELECT * FROM table' | psql database >> test.out

from your terminal