pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCreating Textfiles out of tables
3+ messages / 3 participants
[nested] [flat]
* Creating Textfiles out of tables
@ 1999-02-16 13:05 Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>
1999-02-16 13:44 ` Re: [GENERAL] Creating Textfiles out of tables jose' soares <sferac@bo.nettuno.it>
1999-02-17 02:29 ` Re: [ADMIN] Creating Textfiles out of tables Terry Mackintosh <terry@terrym.com>
0 siblings, 2 replies; 3+ messages in thread
From: Martin Möderndorfer @ 1999-02-16 13:05 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org; pgsql-admin@postgresql.org
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@linux.stuco.uni-klu.ac.at
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] Creating Textfiles out of tables
1999-02-16 13:05 Creating Textfiles out of tables Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>
@ 1999-02-16 13:44 ` jose' soares <sferac@bo.nettuno.it>
1 sibling, 0 replies; 3+ messages in thread
From: jose' soares @ 1999-02-16 13:44 UTC (permalink / raw)
To: Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>; +Cc: pgsql-sql; pgsql-general@postgresql.org; pgsql-admin@postgresql.org
Martin Möderndorfer ha scritto:
> 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@linux.stuco.uni-klu.ac.at
psql joe
joe=> \t
turned off output headings and row count
joe=> \f :
field separator changed to ':'
joe=> select * from btmm;
a : 13.2:FO
b : 1.32:FO
c :31.32:RO
if you type \o file_name
the result will be stored to a file named "file_name".
--
- Jose' -
And behold, I tell you these things that ye may learn wisdom; that ye may
learn that when ye are in the service of your fellow beings ye are only
in the service of your God. - Mosiah 2:17 -
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [ADMIN] Creating Textfiles out of tables
1999-02-16 13:05 Creating Textfiles out of tables Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>
@ 1999-02-17 02:29 ` Terry Mackintosh <terry@terrym.com>
1 sibling, 0 replies; 3+ messages in thread
From: Terry Mackintosh @ 1999-02-17 02:29 UTC (permalink / raw)
To: Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>; +Cc: pgsql-sql; pgsql-general@postgreSQL.org; pgsql-admin@postgreSQL.org
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] Möderndorfer 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@linux.stuco.uni-klu.ac.at
>
Have a great day
Terry Mackintosh <terry@terrym.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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-02-17 02:29 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-16 13:05 Creating Textfiles out of tables Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>
1999-02-16 13:44 ` jose' soares <sferac@bo.nettuno.it>
1999-02-17 02:29 ` Terry Mackintosh <terry@terrym.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox