Yogesh Kushwaha yk2kus

Importing and exporting CSV files with PostgreSQL

Let’s see how to use PostgreSQL to import and export CSV files painlessly with the COPY command.

Import CSV into table t_words:

COPY t_words FROM '/path/to/file.csv' DELIMITER ',' CSV;

You can tell quote char with QUOTE and change delimiter with DELIMITER.

Office Web Apps Viewer

('.ppt' '.pptx' '.doc', '.docx', '.xls', '.xlsx')

http://view.officeapps.live.com/op/view.aspx?src=[OFFICE_FILE_URL]

<iframe src='https://view.officeapps.live.com/op/embed.aspx?src=[OFFICE_FILE_URL]' width='px' height='px' frameborder='0'>
</iframe>

	# IE users need: https://get.adobe.com/reader/

	from PyPDF2 import PdfFileWriter, PdfFileReader

	output = PdfFileWriter()
	ipdf = PdfFileReader(open('old.pdf', 'rb'))

	for i in xrange(ipdf.getNumPages()):
	page = ipdf.getPage(i)
	output.addPage(page)

	# Inspired from https://pythonprogramming.net/encryption-and-decryption-in-python-code-example-with-explanation/
	# PyCrypto docs available at https://www.dlitz.net/software/pycrypto/api/2.6/

	from Crypto.Cipher import AES
	import base64, os

	def generate_secret_key_for_AES_cipher():
	# AES key length must be either 16, 24, or 32 bytes long
	AES_key_length = 16 # use larger value in production
	# generate a random secret key with the decided key length

	cd repository
	git checkout --orphan orphan_name
	git rm -rf .
	rm '.gitignore'
	echo "#Title of Readme" > README.md
	git add README.md
	git commit -a -m "Initial Commit"
	git push origin orphan_name

	Run this command to install MG-CLI:
	sudo apt-get update && wget https://minergate.com/download/deb-cli -O minergate-cli.deb && sudo dpkg -i minergate-cli.deb

	to start miner (4 cores for BCN) use this command:
	minergate-cli -user <[email protected]> -bcn 4


	Feel free to send some of your earnings to me:
	BTC (Don't attempt to send other coins to this address!): 17f77AYHsQbdsB1Q6BbqPahJ8ZrjFLYH2j

Yogesh Kushwaha yk2kus

Importing and exporting CSV files with PostgreSQL

Office Web Apps Viewer

OneDrive Embed Links