System catalog and identifying
От | ville80@salo.salonseutu.fi (9902468) |
---|---|
Тема | System catalog and identifying |
Дата | |
Msg-id | c8493963.0208010109.49542500@posting.google.com обсуждение исходный текст |
Ответы |
Re: System catalog and identifying
|
Список | pgsql-general |
Hi all! Didn't find any info on this, so if I missed it please guide me to the info thx. I know the name of the table and now I need to know what columns this table has. First I search system catalog named pg_class inorder to get the postgre id of the table named relfilenode: select relfilenode from pg_class where relname = 'table_name'; after that I search all column names from pg_attribute, like this: select attname from pg_attribute where attrelid = relfilenode; unfortunately, this returns correct names, but also some names that the system uses. How can I exclude these names? EXAMPLE: I get the following results: tableoid * cmax * xmax * cmin * xmin * oid * ctid * sarake_id nimi kuvaus tyyppi help taulu_id everything marked with * is unwanted. Thanks beforehand! -9902468
В списке pgsql-general по дате отправления: