Totally new, two main problems. - Mailing list pgsql-general

From wepwep
Subject Totally new, two main problems.
Date
Msg-id 1301433633772-4270202.post@n5.nabble.com
Whole thread Raw
Responses Re: Totally new, two main problems.  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Im learning pg sql and psql in general. Im using console psql in windows. For
now, i installed it correctly and execute it, ok.

My first problem is that i dont know how to execute a pgsql script when im
in the psql program.
CREATE FUNCTION sales_tax(subtotal real) RETURNS real AS $$
 BEGIN
    RETURN subtotal * 0.06;
END;
$$ LANGUAGE plpgsql;


This is in c:/2tri/scr.sql. How i can execute that?

Also my other problem is with pgsql syntax. How i can print a text to the
console for checking, debugign, etc, i dont see anything to do that.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Totally-new-two-main-problems-tp4270202p4270202.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Derrick Rice
Date:
Subject: Re: What could keep a connection / query alive?
Next
From: Adrian Klaver
Date:
Subject: Re: Date conversion using day of week