This afternoon I was using PGAdmin and needed to export some data from a query I had run but realized I wasn’t even sure if PGAdmin had this capability. Typically I would export data using the PSQL command line but since I was already working in PGAdmin I wanted to try and figure out if the capability existed and if so how to do it. After some playing around I was able to figure out how to export PGAdmin data to a CSV (Comma Separated Value) format that would be Microsoft Excel friendly. Follow the directions below to export PGAdmin data to a .CSV file to open in MS Excel.column separator, Comma Separated Values, CR/LF, CSV, Excel, export, local charset, Microsoft Excel, MS Excel, pgAdmin, postgres, PostgreSQL, psql, row separator
Posts Tagged “Microsoft Excel”
Oct 15 2010
Jun 09 2009
GoogleDocs is awesome. There is nothing better than storing all of your spreadsheets, documents, forms, and presentations in an online secure location. Not only that but you can open and edit from any PC in the world at any time without having to worry about access, etc.
Today I was creating a spreadsheet on GoogleDocs to list account numbers and serial numbers that were sequential though they also contained letters. An example of the set of numbers I was trying to enter quickly is listed below.account number, CONCATENATE, formula, google spreadsheet, googledocs, Microsoft Excel, RIGHT, sequential, serial number, spreadsheet
Oct 16 2008
Its fairly easy to merge Microsoft Excel fields together but you have to be aware of formulas and then with how to pull that data out of the formula to save it on its own. I used this to merge title, first name, and last name together. Follow the directions below and you should have no problems merging Excel fields together.
1. New Column: Add the below formula to a new column.
=CONCATENATE(A1,” “,B1,” “,C1)cells, copy, Excel, fields, formula, Microsoft Excel, MS Excel, paste, paste special, spreadsheet