pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRunning a file
7+ messages / 5 participants
[nested] [flat]
* Running a file
@ 2000-12-24 13:18 Thomas SMETS <tsmets@altern.org>
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:39 Anthony E . Greene <agreene@pobox.com>
parent: Thomas SMETS <tsmets@altern.org>
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 14:24 Raju Mathur <raju@linux-delhi.org>
parent: 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 17:24 Brett W. McCoy <bmccoy@chapelperilous.net>
parent: 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-25 14:03 Kaare Rasmussen <kar@webline.dk>
parent: Brett W. McCoy <bmccoy@chapelperilous.net>
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-30 00:50 Thomas SMETS <tsmets@altern.org>
parent: Brett W. McCoy <bmccoy@chapelperilous.net>
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
* Re: [SQL] Running a file
@ 2000-12-30 01:05 Thomas SMETS <tsmets@altern.org>
parent: Raju Mathur <raju@linux-delhi.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
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