The need to know if a field is using/connected to a sequence

Поиск
Список
Период
Сортировка
От Ries van Twisk
Тема The need to know if a field is using/connected to a sequence
Дата
Msg-id 002001c2ff2b$757fc6a0$f100000a@IT001
обсуждение исходный текст
Ответы Re: The need to know if a field is using/connected to a sequence  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Список pgsql-sql
I currently use this to get field information of a table:
Now I just want to know (boolean field maby??) if a field is using/connected
to q sequence or not.
Which table should I access to get this information


SELECT
a.attnum,
a.attname AS field,
t.typname AS type,
a.attlen AS length,
a.atttypmod AS lengthvar,
a.attnotnull AS notnull
FROM
pg_class c,
pg_attribute a,
pg_type t
WHERE
c.relname = 'your_table_name'
and a.attnum > 0
and a.attrelid = c.oid
and a.atttypid = t.oid
ORDER BY a.attnum



В списке pgsql-sql по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: question about visibilty while updating multiple rows .
Следующее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: The need to know if a field is using/connected to a sequence