Re: oracle script to postgresql - Mailing list pgsql-general

FERREIRA William (COFRAMI) wrote:
> hi,
>
> i'm trying to port an oracle script to postgresql, but i don't find
> any alternative for some problems this is an extract of the oracle
> script :
>
> DEFINE MDNSImportBlobDirectory =
> C:\Temp\_lm_\ExternalTablesSpace\mdns;
> @createFraweWorkTables_script.ddl; @createMDNSProcStockImport.sql
> &MDNSImportBlobDirectory;
>
> so i need to declare variables and to pass them to others script
>
> is there any alternative for doing this ?

You can define variables in PG functions and pass them to other
functions:

DECLARE

   numRows integer := 5;

BEGIN

   perform add_5_min_table(numRows);

--
Guy Rouillier