You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by si...@portosdobrasil.gov.br on 2010/03/02 20:13:09 UTC

running postgreSQL script

Does anybody know how to cal a postgreSQL script from inside of another one?

With Oracle I used:

@script.sql

Does anyone know the equivalent with postgreSQL?

Thanks

Siomara

Re: running postgreSQL script

Posted by Daniel H A Lima <em...@yahoo.com.br>.
Take a look at:

http://download.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm
http://www.postgresql.org/files/documentation/books/aw_pgsql/node143.html

--- Em ter, 2/3/10, Daniel H A Lima <em...@yahoo.com.br> escreveu:

De: Daniel H A Lima <em...@yahoo.com.br>
Assunto: Re: running postgreSQL script
Para: "Commons Users List" <us...@commons.apache.org>
Data: Terça-feira, 2 de Março de 2010, 16:29

@script_name is a SQL Plus sintax

If you are using psql (PostgreSQL command line), you can try \i script_name



--- Em ter, 2/3/10, siomara@portosdobrasil.gov.br <si...@portosdobrasil.gov.br> escreveu:

De: siomara@portosdobrasil.gov.br <si...@portosdobrasil.gov.br>
Assunto: running postgreSQL script
Para: user@commons.apache.org
Data: Terça-feira, 2 de Março de 2010, 16:13

Does anybody know how to cal a postgreSQL script from inside of another one?

With Oracle I used:

@script.sql

Does anyone know the equivalent with postgreSQL?

Thanks

Siomara



      ____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com


      ____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Re: running postgreSQL script

Posted by Daniel H A Lima <em...@yahoo.com.br>.
@script_name is a SQL Plus sintax

If you are using psql (PostgreSQL command line), you can try \i script_name



--- Em ter, 2/3/10, siomara@portosdobrasil.gov.br <si...@portosdobrasil.gov.br> escreveu:

De: siomara@portosdobrasil.gov.br <si...@portosdobrasil.gov.br>
Assunto: running postgreSQL script
Para: user@commons.apache.org
Data: Terça-feira, 2 de Março de 2010, 16:13

Does anybody know how to cal a postgreSQL script from inside of another one?

With Oracle I used:

@script.sql

Does anyone know the equivalent with postgreSQL?

Thanks

Siomara



      ____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com