select relname as table, attname as column from pg_class c join pg_attribute
a on c.oid=a.attrelid join pg_attrdef d on a.attnum=d.adnum where
adsrc='nextval(\'"SEQUENCE_NAME_SEQ"\'::text)'\ AND d.adrelid=c.oid;
There may be a more efficient query, but I wasn't too worried about figuring
it out...
Oliver Elphick wrote:
> On Sun, 2003-01-26 at 13:53, D'Arcy J.M. Cain wrote:
>
> > This year, my team is planning on improving the MONEY type. Of course, we can
> > always make it a user defined type if PostgreSQL doesn't want it. We will at
> > least put it into contrib. However, if people t
Sweet, worked the charm, thanks!
P.S. Anyone know why it takes several hours[1] for my posts to come through
the list?
[1] Posted a message at ~9am friday, it got back to me ~4pm!
- Original Message -
From: "Bhuvan A" <[EMAIL PROTECTED]>
To: "Luke Pascoe" <[EMAIL PROTECTED]>
Cc: <[EMAIL
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]
Uh, we have ALTER DATABASE, but it doesn't rename. If no one is
connected, you can connect to template1 and modify pg_database table to
rename. That _should_ work.
---
Wei Weng wrote:
> Can I use a SQL statement to rename
