Re: For the PG experts

On Jun 16, 3:34=A0pm, jul...@[EMAIL PROTECTED]
 (Julius Tuskenis) wrote:
> Hi Laurent.
>
> As I understand where is no direct link between sequence and the table
> column. You should see pg_attrdef table.
> Query SELECT =A0pg_get_expr(adbin,adrelid) =A0FROM pg_attrdef; will
retur=
n
> you all default values of the columns. Among them you will find
> nextval('your_sequence'::regclass).
>
> Hope that helps...


Right, or more precisely, to get the default for your primary key
column
   myschema.mytab.mycol
use:

SELECT pg_catalog.pg_get_expr(d.adbin, d.adrelid)
  FROM pg_catalog.pg_attrdef d
  JOIN pg_catalog.pg_attribute a ON d.adrelid =3D a.attrelid AND d.adnum
=3D a.attnum
  JOIN pg_catalog.pg_class c ON c.oid =3D a.attrelid
  JOIN pg_catalog.pg_namespace n ON n.oid =3D c.relnamespace
WHERE n.nspname =3D 'myschema' AND c.relname =3D 'mytab' AND a.attname =3D
'mycol'
ORDER BY a.attnum

Gives you something like:
   nextval('mytab_mycol_seq'::regclass)
The quotet part being the sequence in use.

Where do I get this? Try psql -E  and work from there. (Shows the
queries psql uses to retrieve its data.)


But all of this is hardly on topic here. Please turn to
   pgsql.admin (pgsql-admin(at)postgresql(dot)org)
or
   pgsql.general (pgsql-general(at)postgresql(dot)org)


Regards
Erwin