On Wed, 4 Apr 2007, Alexander B. wrote:
Hi,
I tried to find, but I didn't, I would like to know what's the view to
list all sequences!
You can get the info from pg_class like so:
SELECT n.nspname
, c.relname
FROM pg_class c
, pg_namespace n
WHERE c.relnamespace = n.OID
AND c
Alexander B. wrote:
Hi,
I tried to find, but I didn't, I would like to know what's the view to
list all sequences!
Thank you
\ds
or
select * from pg_class where relkind = 'S';
---(end of broadcast)---
TIP 4: Have you searched our list archives
* smacks your hand for using uppercase letters *
Another big no no is not keeping your create sequences for sequences ( what
a pun ) in a file somewhere.
Otherwise you can't drop them because you don't remember what parameters
they took ( but you can always, as you say, look at system tables )
Che
Thanks, worked like a charm.
Danny L. Morgan
-Original Message-
From: bruno [mailto:bruno@;wolff.to]
Sent: Monday, October 28, 2002 4:42 PM
To: dmorgan
Cc: pgsql-admin
Subject: Re: [ADMIN] Sequences
On Mon, Oct 28, 2002 at 14:00:44 -0500,
Danny Morgan <[EMAIL PROTECTED]> wrot
On Mon, Oct 28, 2002 at 14:00:44 -0500,
Danny Morgan <[EMAIL PROTECTED]> wrote:
> I have a strange dilemma. I've created a couple sequences I can't
> remove.
>
> Here is an example
>
> I can
> CREATE SEQUENCE "count1" ..;
> DROP SEQUENCE count1;
>
> I can't
> CREAT
