Easytech blog

Categories
- Adobe Flex / Air (2)
- Drupal (4)
- Linux (3)
- Oracle (6)
  - Application Framework (OAF) (1)
  - Application Server (2)
  - Database (3)
  - DBA (1)
  - E-Business Suite (1)
  - Technology (2)
- Private (3)
- Programming and Scripting (10)
  - PHP (7)
- Uncategorized (2)
Recent Posts
Archives
Blogroll
Meta

24 06 2008

Dumping CSV data with PostgreSQL

Posted by: miquel in Database

Many times you will need to quickly executa a query in PostgreSQL and dump
the results to comma delimited value (CSV) file. In this post I’ll show you
a quick way to do it with the psql command in PostgreSQL.
Just copy the following to a file called dump2csv.sql

-- ==================================================================---- This script will execute and SQL query using the psql command-- and dump the results to a file called /tmp/result.csv in-- CSV format. You can change the separator by modifing the line-- pset fieldsetp ,---- To execute it:----  $ psql -h  -U  -d  -W -f dump2csv.sql—- ==================================================================—- Uses the following psql options:–   a toggle between unaligned and aligned output mode–   t show only rows–   o [FILE] send query results to file or |pipe– atpset fieldsep ,o /tmp/result.csv– queryselect ..

To dump the result of the query to a file do:

$ psql -h -U -d -W -f dump2csv.sql

the result of your query will be stored in /tmp/result.csv.

Comments Off

01 04 2008

Adobe Air for Linux

Posted by: miquel in Linux

A screenshot of Kuler and Pixelperfect running on Adobe Air for Linux Yesterday Adobe released the first alpha of Adobe Air for Linux. I played with it for a while and was quite impressed with it. The installation went along flawlessly on my Fedora Core 8 and I downloaded a couple of applications that worked quite nicely. In the release notes they mentioned that transparency works when using a composite window manager. I switched on the ‘desktop effects’ (as they are called in FC8) and indeed the apps worked perfectly!

The apps I tried where: kuler and Pixel Perfect. Kuler is an application which stores several hundred color combinations which are all very pretty. Pixel Perfect is a simple application which draws a translucent ruler on the desktop. The ruler can be moved around, resized and you can even change the transparency using the mouse wheel. All worked perfectly under Linux. You can download the source and read the article of how it works here. I still need to test local applications tht make use of Air’s features like the local sqlite database, etc.

What really interests me is to use Air and Flex to build cross platform widgets as well as desktop applications. It seems to me, after having a quick peak at the code that Adobe is really pushing this technology under Linux and is not just writing a half working port for Linux.

I will continue to test is and update this post (or create a new one) with the news. For the moment you can learn more at Adobe labs

Easytech blog

Technological Solutions

Categories

Recent Posts

Archives

Blogroll

Meta

Dumping CSV data with PostgreSQL

Adobe Air for Linux