Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: postgresql007
- Order by date
-
export into csv
test=# COPY (SELECT count(*) FROM pg_class) TO '/tmp/file.csv' CSV; COPY 1 something like this is even more fancy. can you export the result of any query. we implemented this feature for PostgreSQL 8.2 and beyond. best regards, hans Hans-Jürgen Schönig Cybertec Schönig & Schönig...- postgresql007
- Post #5
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to create a pivot table in PostgreSQL?
You can use a function called "crosstab" to do that. It is part of the PostgreSQL contrib-section and it has to be installed separately. Checkout the "contrib/tablefunc" directory inside your sourceball. Hans-Jürgen Schönig Cybertec Schönig & Schönig GmbH URL: http://www.postgresql-support.de...- postgresql007
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
