pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Running a file
7+ messages / 5 participants
[nested] [flat]

* Running a file
@ 2000-12-24 13:18 Thomas SMETS <tsmets@altern.org>
  2000-12-24 13:39 ` Re: Running a file Anthony E . Greene <agreene@pobox.com>
  2000-12-24 14:24 ` Running a file Raju Mathur <raju@linux-delhi.org>
  2000-12-24 17:24 ` Re: [SQL] Running a file Brett W. McCoy <bmccoy@chapelperilous.net>
  0 siblings, 3 replies; 7+ messages in thread

From: Thomas SMETS @ 2000-12-24 13:18 UTC (permalink / raw)
  To: psql Admin <pgsql-admin@postgresql.org>; pgsql-sql




I'm runnin postgres 7.?? (Last RPM package available from the site).

I want to create a few DB creation scripts so I can "publish" that
afterwards.
On Oracle there's a such possibility but I haven't seen anything
comaprable in the docs ... 
I however think I'm missing one of the very first possibility of
"pgsql".
Could someone point me were I could find some more infos on that matter
?

Tx,

Thomas,

p.s. : 
Merry Xmas for some / Enjoy Ead / Merry Solstice for the others :-)



-- 
Sun Dec 24 13:32:35 CET 2000

Thomas SMETS                        e-mail : tsmets@altern.org
Av. de la Brabançonne 133 / 3       Tel. : +32 (0)2 742. 05. 94.
1030 Bruxelles
======= Quote of the Day =========
The FALAFEL SANDWICH lands on my HEAD and I become a VEGETARIAN ...
========= End of Quote ===========



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Running a file
  2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
@ 2000-12-24 13:39 ` Anthony E . Greene <agreene@pobox.com>
  2 siblings, 0 replies; 7+ messages in thread

From: Anthony E . Greene @ 2000-12-24 13:39 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org

On Sun, 24 Dec 2000 08:18:50 Thomas SMETS wrote:
>I'm runnin postgres 7.?? (Last RPM package available from the site).
>
>I want to create a few DB creation scripts so I can "publish" that
>afterwards.
>On Oracle there's a such possibility but I haven't seen anything
>comaprable in the docs ... 

man pg_dump

-- 
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/;
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/;



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Running a file
  2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
@ 2000-12-24 14:24 ` Raju Mathur <raju@linux-delhi.org>
  2000-12-30 01:05   ` Re: [SQL] Running a file Thomas SMETS <tsmets@altern.org>
  2 siblings, 1 reply; 7+ messages in thread

From: Raju Mathur @ 2000-12-24 14:24 UTC (permalink / raw)
  To: psql Admin <pgsql-admin@postgresql.org>; pgsql-sql

Hi Thomas,

Is it possible you're looking for:

   psql -f script.sql <database>

?

Regards,

-- Raju

>>>>> "Thomas" == Thomas SMETS <tsmets@altern.org> writes:

    Thomas> I'm runnin postgres 7.?? (Last RPM package available from
    Thomas> the site).

    Thomas> I want to create a few DB creation scripts so I can
    Thomas> "publish" that afterwards.  On Oracle there's a such
    Thomas> possibility but I haven't seen anything comaprable in the
    Thomas> docs ...  I however think I'm missing one of the very
    Thomas> first possibility of "pgsql".  Could someone point me were
    Thomas> I could find some more infos on that matter ?

    Thomas> Tx,

    Thomas> Thomas,

    Thomas> p.s. : Merry Xmas for some / Enjoy Ead / Merry Solstice
    Thomas> for the others :-)
-- 
Raju Mathur          raju@kandalaya.org           http://kandalaya.org/



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: [SQL] Running a file
  2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
  2000-12-24 14:24 ` Running a file Raju Mathur <raju@linux-delhi.org>
@ 2000-12-30 01:05   ` Thomas SMETS <tsmets@altern.org>
  0 siblings, 0 replies; 7+ messages in thread

From: Thomas SMETS @ 2000-12-30 01:05 UTC (permalink / raw)
  To: raju@linux-delhi.org; +Cc: psql Admin <pgsql-admin@postgresql.org>; pgsql-sql


Yep,

Tx,

Thomas,

p.s. Sorry for the stupid question 








Raju Mathur wrote:
> 
> Hi Thomas,
> 
> Is it possible you're looking for:
> 
>    psql -f script.sql <database>
> 
> ?
> 
> Regards,
> 
> -- Raju
> 
> >>>>> "Thomas" == Thomas SMETS <tsmets@altern.org> writes:
> 
>     Thomas> I'm runnin postgres 7.?? (Last RPM package available from
>     Thomas> the site).
> 
>     Thomas> I want to create a few DB creation scripts so I can
>     Thomas> "publish" that afterwards.  On Oracle there's a such
>     Thomas> possibility but I haven't seen anything comaprable in the
>     Thomas> docs ...  I however think I'm missing one of the very
>     Thomas> first possibility of "pgsql".  Could someone point me were
>     Thomas> I could find some more infos on that matter ?
> 
>     Thomas> Tx,
> 
>     Thomas> Thomas,
> 
>     Thomas> p.s. : Merry Xmas for some / Enjoy Ead / Merry Solstice
>     Thomas> for the others :-)
> --
> Raju Mathur          raju@kandalaya.org           http://kandalaya.org/

-- 
Sat Dec 30 00:39:50 CET 2000

Thomas SMETS                        e-mail : tsmets@altern.org
Av. de la Brabançonne 133 / 3       Tel. : +32 (0)2 742. 05. 94.
1030 Bruxelles
======= Quote of the Day =========
Ye've also got to remember that ... respectable people do the most
astonishin'
things to preserve their respectability.  Thank God I'm not respectable.
		-- Ruthven Campbell Todd
========= End of Quote ===========



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: [SQL] Running a file
  2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
@ 2000-12-24 17:24 ` Brett W. McCoy <bmccoy@chapelperilous.net>
  2000-12-25 14:03   ` Re: [SQL] Running a file Kaare Rasmussen <kar@webline.dk>
  2000-12-30 00:50   ` Re: Running a file Thomas SMETS <tsmets@altern.org>
  2 siblings, 2 replies; 7+ messages in thread

From: Brett W. McCoy @ 2000-12-24 17:24 UTC (permalink / raw)
  To: Thomas SMETS <tsmets@altern.org>; +Cc: psql Admin <pgsql-admin@postgresql.org>; pgsql-sql

On Sun, 24 Dec 2000, Thomas SMETS wrote:

> I'm runnin postgres 7.?? (Last RPM package available from the site).
>
> I want to create a few DB creation scripts so I can "publish" that
> afterwards.
> On Oracle there's a such possibility but I haven't seen anything
> comaprable in the docs ...
> I however think I'm missing one of the very first possibility of
> "pgsql".
> Could someone point me were I could find some more infos on that matter
> ?

Are you talking about writing external scripts and importing them into
Postgres in a manner similar to the @ function in SQL*Plus?  In psql, you
can use \i to import scripts to do that.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Reading is to the mind what exercise is to the body.




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: [SQL] Running a file
  2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
  2000-12-24 17:24 ` Re: [SQL] Running a file Brett W. McCoy <bmccoy@chapelperilous.net>
@ 2000-12-25 14:03   ` Kaare Rasmussen <kar@webline.dk>
  1 sibling, 0 replies; 7+ messages in thread

From: Kaare Rasmussen @ 2000-12-25 14:03 UTC (permalink / raw)
  To: pgsql-sql; +Cc: psql Admin <pgsql-admin@postgresql.org>; pgsql-sql

> Are you talking about writing external scripts and importing them into
> Postgres in a manner similar to the @ function in SQL*Plus?  In psql, you
> can use \i to import scripts to do that.

If it's to be used in shell scripts, it's just as easy to pipe:

psql dbname<create_table.sql

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lørdag 11.00-17.00       Web:      www.suse.dk



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Running a file
  2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
  2000-12-24 17:24 ` Re: [SQL] Running a file Brett W. McCoy <bmccoy@chapelperilous.net>
@ 2000-12-30 00:50   ` Thomas SMETS <tsmets@altern.org>
  1 sibling, 0 replies; 7+ messages in thread

From: Thomas SMETS @ 2000-12-30 00:50 UTC (permalink / raw)
  To: Brett W. McCoy <bmccoy@chapelperilous.net>; +Cc: pgsql-sql

Tx,

Thomas,


"Brett W. McCoy" wrote:
> 
> On Sun, 24 Dec 2000, Thomas SMETS wrote:
> 
> > I'm runnin postgres 7.?? (Last RPM package available from the site).
> >
> > I want to create a few DB creation scripts so I can "publish" that
> > afterwards.
> > On Oracle there's a such possibility but I haven't seen anything
> > comaprable in the docs ...
> > I however think I'm missing one of the very first possibility of
> > "pgsql".
> > Could someone point me were I could find some more infos on that matter
> > ?
> 
> Are you talking about writing external scripts and importing them into
> Postgres in a manner similar to the @ function in SQL*Plus?  In psql, you
> can use \i to import scripts to do that.
> 
> -- Brett
>                                      http://www.chapelperilous.net/~bmccoy/
> ---------------------------------------------------------------------------
> Reading is to the mind what exercise is to the body.

-- 
Sat Dec 30 00:39:50 CET 2000

Thomas SMETS                        e-mail : tsmets@altern.org
Av. de la Brabançonne 133 / 3       Tel. : +32 (0)2 742. 05. 94.
1030 Bruxelles
======= Quote of the Day =========
Ye've also got to remember that ... respectable people do the most
astonishin'
things to preserve their respectability.  Thank God I'm not respectable.
		-- Ruthven Campbell Todd
========= End of Quote ===========



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2000-12-30 01:05 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-24 13:18 Running a file Thomas SMETS <tsmets@altern.org>
2000-12-24 13:39 ` Anthony E . Greene <agreene@pobox.com>
2000-12-24 14:24 ` Raju Mathur <raju@linux-delhi.org>
2000-12-30 01:05   ` Thomas SMETS <tsmets@altern.org>
2000-12-24 17:24 ` Brett W. McCoy <bmccoy@chapelperilous.net>
2000-12-25 14:03   ` Kaare Rasmussen <kar@webline.dk>
2000-12-30 00:50   ` Thomas SMETS <tsmets@altern.org>

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