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
Hi,
I tried to find, but I didn't, I would like to know what's the view to
list all sequences!
Thank you
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
gan
Sent: 28 October 2002 18:57
To: [EMAIL PROTECTED]
Subject: [ADMIN] Sequences
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
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
CREATE SEQUENCE "count1ListItems1" ..;
DROP SEQUENCE count1ListItems1;
It stat
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
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
CREATE SEQUENCE "count1ListItems1" ..;
DROP SEQUENCE count1ListItems1;
It stat
