Hey there,
Does anybody have a nice way to identify what table.column is using a
particular sequence on a database-wide basis?
--Thanks.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Here is a function that I use to list fk(triggers) on a table. Execute the
function to get the trigger name and then - drop trigger "trigger_name" on
table_name;
hth
-- Version 1.0, June 2002
-- Marie G. Tuite
-- Function lists FK by table.
-- To execute:
-- begin;select fn_list_fk(&
project=# select version();
version
-
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Running above, am trying to drop the primary key, but get the follwing
error.
project=# alter table cl
Hello list,
Is there a system attribute or table or ? providing record count by table?
Thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Use \df function_name to get the argument list and then drop it.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Peter Atkins
> Sent: Tuesday, August 13, 2002 12:30 PM
> To: [EMAIL PROTECTED]
> Subject: [SQL] Delete function without knowing the elem
