From: | Terry Mackintosh <terry(at)terrym(dot)com> |
---|---|
To: | Martin Möderndorfer <mmoedern(at)linux(dot)stuco(dot)uni-klu(dot)ac(dot)at> |
Cc: | pgsql-sql(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org, pgsql-admin(at)postgreSQL(dot)org |
Subject: | Re: [ADMIN] Creating Textfiles out of tables |
Date: | 1999-02-17 02:29:17 |
Message-ID: | Pine.LNX.3.95.990216212522.1754A-100000@terry1.acun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hi Martin
One why (there may be a better way), would be to do a 'select...into table
...from ....', now that you have the result set you want in a temp table,
use the copy command ( in psql do '\h copy' for help.)
Also, for select help do (in side psql) '\h select'.
Hope that helps
Terry
On Tue, 16 Feb 1999, Martin [iso-8859-1] Mderndorfer wrote:
> Hi,
>
> i have some tables and want to extract results of a query on them into a
> text-file. it should be possible to insert ":","{" between the different
> tuples.
>
> Any ideas
>
> MArtin
> mmoedern(at)linux(dot)stuco(dot)uni-klu(dot)ac(dot)at
>
Have a great day
Terry Mackintosh <terry(at)terrym(dot)com> http://www.terrym.com
sysadmin/owner I'm excited about life! How about YOU!?
Professional Web Hosting and site design to include programming
Proudly powered by R H Linux 4.2, Apache 1.3.x, PHP 3.x, PostgreSQL 6.x
-----------------------------------------------------------------------
Only if you know where you're going can you get there.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Mercer | 1999-02-17 03:02:30 | slow inserts and updates on large tables |
Previous Message | Bryan Mattern | 1999-02-17 00:09:26 | GIS/GPS Experiences with pgsql? |
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Möderndorfer | 1999-02-17 19:03:04 | Question about SQL FUnction |
Previous Message | Martin Möderndorfer | 1999-02-16 17:50:19 | Creating Textfiles out of tables II |