Yes, I know that one.
What I want to do however is within a stored procedure make a call and
store all tables in a given schema in a list.
Is this something you can answer?
thanks
J.V.
On 9/29/2011 3:25 AM, Richard Huxton wrote:
On 29/09/11 02:33, J.V. wrote:
Is is possible within a
On 09/30/11 12:24 AM, J.V. wrote:
What I want to do however is within a stored procedure make a call and
store all tables in a given schema in a list.
so procedure1 calls procedure2 (not sure why this extra level of
procedures, but I'm playing along)
and procedure2 does SELECT table_name
What data types do I have access to in a stored proc?
I cannot seem to find the stored procedure manual.
I am not speaking of database field/column data types, but rather
stored proc data types.
Regards,
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On 09/30/11 12:59 AM, J.V. wrote:
What data types do I have access to in a stored proc?
I cannot seem to find the stored procedure manual.
http://www.postgresql.org/docs/current/static/plpgsql.html
I am not speaking of database field/column data types, but rather
stored proc data types.
On 09/30/11 1:13 AM, J.V. wrote:
thanks for the help, we have a production schema with 80 tables and a
few of the tables have consumed the max limit for the id field, so I
have to write a program (stored functions would be the fastest way to
do this), that will go and drop the sequence, create
On 09/30/11 1:23 AM, John R Pierce wrote:
convert the fields to bigint which are 64 bit and not likely to wrap
around any time in this century
indeed, this is as simple as ...
alter table tblname alter column id type bigint;
of course, you'll need to alter all the FK fields that refer to
On 09/30/11 1:28 AM, John R Pierce wrote:
On 09/30/11 1:23 AM, John R Pierce wrote:
convert the fields to bigint which are 64 bit and not likely to wrap
around any time in this century
indeed, this is as simple as ...
alter table tblname alter column id type bigint;
of course, you'll
For tables that already exist and have a foreign key relationship, is
there an equivalent alter statement for the statement below?
Does this mean that if table xxx.id primary key value changes, the
foreign key value will change as well?
If this is the case, then would not have to match up
On 30 September 2011 11:20, J.V. jvsr...@gmail.com wrote:
For tables that already exist and have a foreign key relationship, is there
an equivalent alter statement for the statement below?
Does this mean that if table xxx.id primary key value changes, the foreign
key value will change as
On 09/30/11 2:09 AM, J.V. wrote:
Some tables have millions of rows,
well, something like UPDATE tablename SET
id=generate_series(1,numberofrows); will update every row to a
sequential value. However, I have no idea how you would match the
foreign key references in other tables to these new
On 09/30/2011 11:41 PM, John R Pierce wrote:
On 09/30/11 2:09 AM, J.V. wrote:
Some tables have millions of rows,
well, something like UPDATE tablename SET
id=generate_series(1,numberofrows); will update every row to a
sequential value. However, I have no idea how you would match the
foreign
On 29/09/11 02:33, J.V. wrote:
Is is possible within a stored procedure to read all the tables in a
schema into a list?
[snip]
I need to extract this meta-data for a project.
Apart from information_schema mentioned elsewhere, start psql with -E
and then try \dt and similar - it will show
Is is possible within a stored procedure to read all the tables in a
schema into a list?
From that list and for each table is it possible to find the foreign
keys in that table?
From that list of foreign keys, is it possible to find out which field
in which table the FK corresponds to?
I
On 09/28/11 6:33 PM, J.V. wrote:
Is is possible within a stored procedure to read all the tables in a
schema into a list?
From that list and for each table is it possible to find the foreign
keys in that table?
From that list of foreign keys, is it possible to find out which field
in which
Hi All,
I am having an issue with a function where it used to run in a previous
installation of postgres under windows. The box has since been
decommissioned so I am unable to check exactly what version it was though it
was version 8 under winxp.
I am now running postgres 8.2.5 Under OSX 10.5.3
Damian Georgiou wrote:
Hi All,
I am having an issue with a function where it used to run in a previous
installation of postgres under windows. The box has since been
ERROR: function sp_schedulefromdate(unknown) does not exist
LINE 1: select sp_scheduleFromDate('2008-01-01');
Damian Georgiou wrote:
I am having an issue with a function where it used to run in a previous
installation of postgres under windows. The box has since been
decommissioned so I am unable to check exactly what version it was though it
was version 8 under winxp.
I am now running postgres 8.2.5
Harpreet Dhaliwal wrote:
lately I have been looking at difference between a Stored
Proc and User Defined Functions in other RDBMS like Sql
Server / Oracle.
Nomenclature varies wildly between different Database
Management Systems. Be careful.
The SQL standard (2005) speaks of SQL-invoked
Hi,
lately I have been looking at difference between a Stored Proc and User
Defined Functions in other RDBMS like Sql Server / Oracle.
However, in postgresql, I think Stored Procs are wrapped around in User
Defined functions, if I am not wrong.
The following is the list of main differences b/w a
I'm trying to figure out how to do in Postgres what I already pretty well understand
in
DB2: Create a stored procedure that accepts a couple of arguments, does a look-up
in a table using those args in a where clause, and then return a boolean result of
whether a matching row was found. Or
On Tue, 11 Jul 2000, Randall Parker wrote:
I'm trying to figure out how to do in Postgres what I already pretty well understand
in
DB2: Create a stored procedure that accepts a couple of arguments, does a look-up
in a table using those args in a where clause, and then return a boolean
Hi,
2) Is CREATE FUNCTION pretty much a logical equivalent to CREATE
PROCEDURE in other RDBMSs?
I not sure how it is in other DBs, but a little differention is here; in
current state is not available create routines that retuns tuple.
Stored procs can returns tuples... but I'd like to
22 matches
Mail list logo