Sim Zacks wrote:
Do I need to use a specific language in a function to do this or does
it work as native SQL, as it would in T-SQL?
You need to use a specific language.
What I would like to do is something like -
(pseudo code)
declare cursor for select relname from pg_statio_user_sequences
open cur
I am in the process of testing PostGreSQL for our sales and product
database and I am a little confused about SQL scripting and various
available languages. (My background is mostly MSSQL Server).
I am using the PGAdmin tool and I would like to write a script to
update all sequences to the current
On Thursday 15 April 2004 09:22, [EMAIL PROTECTED] wrote:
> good day toall..
> imm running postgreSQL on linux.
> my main goal is to create a script that will dump a data from our server
> too my local PC. the content of the script would be execute sql command
> in one shot: 1. dump data
> 2. upd
good day toall..
imm running postgreSQL on linux.
my main goal is to create a script that will dump a data from our server too my
local PC. the content of the script would be execute sql command in one shot:
1. dump data
2. update and insert some rows to selected table.
how can i accommplish th
I have written the following function but when I try to run it, I get Error:
ERROR: parser: parse error at or near "". As you can see, there is no
instance of "" in my function. Does anyone have any idea why this is
happening?
CREATE FUNCTION dropifexists(text)
RETURNS text
AS 'DECLARE
numcou
