-
Recent Posts
Recent Comments
Samson on Saving PostgreSQL Query Output… Zubi on Using COPY command in Pos… Naman on Saving PostgreSQL Query Output… wallmail on Using COPY command in Pos… suneelm on Saving PostgreSQL Query Output… Archives
Categories
Meta
Tag Archives: Oracle
Saving PostgreSQL Query Output to File
If you have used Oracle databases, you are probably familiar with the SPOOL command. In Oracle, you can use the SPOOL command to save query output (to file) that gets generated in SQLPLUS. Postgres has the ‘psql’ command line tool … Continue reading
Using COPY command in PostgreSQL
Postgres has a very useful ‘COPY’ command that can be used to transfer data between text files and database tables. This is somewhat similar to Oracle’s SQLLDR utility. I will discuss some of the basic commands to get data from … Continue reading
Posted in Database
Tagged COPY, csv file, database, ETL, Oracle, postgres, PostgreSQL, sqlldr
2 Comments