DEFINITIONS

Definitions More Info.
Definition ID653
TitlePOSTGRESQL
CategoryBASH SCRIPT
DefinitionIMPORT EXPORT with COPY with column names,data from bash
Definition DescriptionWith specific columns: http://stackoverflow.com/questions/24483582/copy-only-some-columns-from-an-input-csv

COPY cpflbf (filenames) FROM '/storage/cronLogs/sqlBackupLogs/sqlBackupLogsBF/BFSqlBackup20160216000501.log';
IMPORT: COPY country FROM '/sqlscripts/country_data.sql'WITH DELIMITER '|';
EXPORT: COPY country TO '/sqlscripts/country_data1.sql' WITH DELIMITER '|' ;
MESSAGES: Query Ekranında Messages TAB ında sonuçları görmek COPY country TO STDOUT WITH DELIMITER '|' ;
RecordBycunay
Record Date05-05-2015 17:30:37
Düzenle
Kopyala
Sil