pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInformation passing, Perl, Unix and Postgresql Database
2+ messages / 2 participants
[nested] [flat]
* Information passing, Perl, Unix and Postgresql Database
@ 2001-05-09 18:38 Issurdatt, Portia CECOM RDEC STCD SRC <Portia.Issurdatt@mail1.monmouth.army.mil>
2001-05-09 22:37 ` Re: Information passing, Perl, Unix and Postgresql Database Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Issurdatt, Portia CECOM RDEC STCD SRC @ 2001-05-09 18:38 UTC (permalink / raw)
To: pgsql-sql
I need to extract information from a database table, do another query on
that information, then pass only the new information to a new table using
postgresql database and Unix.
Any suggestions will be helpful!
Thanks,
Portia
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Information passing, Perl, Unix and Postgresql Database
2001-05-09 18:38 Information passing, Perl, Unix and Postgresql Database Issurdatt, Portia CECOM RDEC STCD SRC <Portia.Issurdatt@mail1.monmouth.army.mil>
@ 2001-05-09 22:37 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto Mello @ 2001-05-09 22:37 UTC (permalink / raw)
To: Issurdatt, Portia CECOM RDEC STCD SRC <Portia.Issurdatt@mail1.monmouth.army.mil>; +Cc: pgsql-sql
On Wed, May 09, 2001 at 02:38:14PM -0400, Issurdatt, Portia CECOM RDEC STCD SRC wrote:
> I need to extract information from a database table, do another query on
> that information, then pass only the new information to a new table using
> postgresql database and Unix.
You might be able to do it with subqueries. PostgreSQL 7.1 has
subqueries in the FROM clause as well al regular sebqueries.
Read the subqueries chapter of Bruce Momjian's PostgreSQL
book for more info, or give us more information. The book is at
http://www.ca.postgresql.org/docs/awbook.html
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
_ _ _ _ _ _ ////|||||||||||||| < domino effect at work
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-09 22:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-09 18:38 Information passing, Perl, Unix and Postgresql Database Issurdatt, Portia CECOM RDEC STCD SRC <Portia.Issurdatt@mail1.monmouth.army.mil>
2001-05-09 22:37 ` Roberto Mello <rmello@cc.usu.edu>
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