Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Scott Marlowe
On Nov 21, 2007 1:07 PM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Scott Marlowe wrote: > > On Nov 21, 2007 12:21 PM, David Fetter <[EMAIL PROTECTED]> wrote: > >> On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote: > >>> On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrot

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Richard Huxton
Scott Marlowe wrote: On Nov 21, 2007 12:21 PM, David Fetter <[EMAIL PROTECTED]> wrote: On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote: On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: Gauthier, Dave wrote: APparently, from "man psql", -c can do only one thing

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Scott Marlowe
On Nov 21, 2007 12:21 PM, David Fetter <[EMAIL PROTECTED]> wrote: > > On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote: > > On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > > > Gauthier, Dave wrote: > > > > APparently, from "man psql", -c can do only one thing at a

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread David Fetter
On Wed, Nov 21, 2007 at 11:10:15AM -0600, Scott Marlowe wrote: > On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > > Gauthier, Dave wrote: > > > APparently, from "man psql", -c can do only one thing at a time. But you > > > could do this with 2-3 commands (or 1 if you want to

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Richard Huxton
Scott Marlowe wrote: On Nov 21, 2007 11:16 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: Scott Marlowe wrote: On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: Or just put everything in one file and use -f And from the more than one way to skin a cat department: cat my.sql

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Scott Marlowe
On Nov 21, 2007 11:16 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > > Scott Marlowe wrote: > > On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > >> Gauthier, Dave wrote: > >>> APparently, from "man psql", -c can do only one thing at a time. But you > >>> could do this with 2

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Richard Huxton
Scott Marlowe wrote: On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: Gauthier, Dave wrote: APparently, from "man psql", -c can do only one thing at a time. But you could do this with 2-3 commands (or 1 if you want to wrap the 2 up in a shell script or something). Here's

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Scott Marlowe
On Nov 21, 2007 10:49 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Gauthier, Dave wrote: > > APparently, from "man psql", -c can do only one thing at a time. But you > > could do this with 2-3 commands (or 1 if you want to wrap the 2 up in a > > shell script or something). Here's an example.

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Richard Huxton
Gauthier, Dave wrote: APparently, from "man psql", -c can do only one thing at a time. But you could do this with 2-3 commands (or 1 if you want to wrap the 2 up in a shell script or something). Here's an example... [snip] psql --dbname mydb -c "\i create_try.sql;" psql --dbname mydb -c "se

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Gauthier, Dave
ay, November 21, 2007 10:50 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] loading a funtion script from a file Pau Marc Munoz Torres <[EMAIL PROTECTED]> schrieb: > Hi > > I've written a sql function in a text file, and now, i would like to upload > into post

Re: [GENERAL] loading a funtion script from a file

2007-11-21 Thread Andreas Kretschmer
Pau Marc Munoz Torres <[EMAIL PROTECTED]> schrieb: > Hi > > I've written a sql function in a text file, and now, i would like to upload > into postgresql an execute, is there any command to do it? as far as I know in > mysql exist source command, is there something similar in postgresql? Of cou

[GENERAL] loading a funtion script from a file

2007-11-21 Thread Pau Marc Munoz Torres
Hi I've written a sql function in a text file, and now, i would like to upload into postgresql an execute, is there any command to do it? as far as I know in mysql exist source command, is there something similar in postgresql? Thanks -- Pau Marc Muñoz Torres Laboratori de Biologia Computacio