i have to make it for my customers. so i have to make it from my project.
tnks.
AhmetYOL
Last Activity: Jan 14 '08, 11:29 AM
Joined: Jul 30 '07
Location:
-
hi all
i share the postgres bin directory. and i run the pg_restore and dump from server. its running now. but if there is another way i want to know it.
Best Regards.Leave a comment:
-
PostgreSQL dump restore from client
hi all,
i am trying to backup and restore Postgre database. At server i can do them perfectly but i couldn't find how can i do this from client?
the system is as below
i am using postgresql 8.2 at windows xp sp2, i am installing postgres only to the server computer. i am only installing .dll files to connect to server to the clients.Connect ing query'ing etc.. running perfectly. Am i have to install postgreSql to the per client... -
hi
i create the type for this function
and the functions latest version is belowCode:create type typ_dupps as (x integer, y integer, z varchar )
...Code:CREATE OR REPLACE FUNCTION "public"."fnc_dupps" (x integer) RETURNS SETOF "pg_catalog"."record" AS $body$ declare sonuc typ_dupps; declare crs_koyler cursor for select
Leave a comment:
-
hi
i have the problem like this but i couldn't solve this yet.
i have the function below;
...Code:CREATE OR REPLACE FUNCTION "public"."fnc_dupps" (x integer, out y integer, out z integer, out t varchar) RETURNS SETOF "pg_catalog"."record" AS $body$ declare cur_koyler cursor for select koy_bolgeid,koy_idno from tbl_koyler; declare k integer; begin
Leave a comment:
-
i found it in this forum.
in loop
tnks.Code:exit when not found;
Leave a comment:
-
Understanding End of Cursor?
Hi all;
How can i catch end of the cursor?
...Code:CREATE OR REPLACE FUNCTION "public"."fnc_rapthsbordro" (bastar date, bittar date, basmuk integer, bitmuk integer, basmak varchar, bitmak varchar, siralama varchar, tip boolean) RETURNS varchar AS $body$ declare intgelirkod integer; declare intgelirkod1 integer; declare gelircurs cursor for select gelirkod_idno from tbl_gelirkodlari
No activity results to display
Leave a comment: