obtaining column names from tables or views
| От | John van Zantvoort |
|---|---|
| Тема | obtaining column names from tables or views |
| Дата | |
| Msg-id | 872c5faa0711280713t4627c24fj2992abe1487df9ed@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: obtaining column names from tables or views
|
| Список | pgsql-sql |
moin,<br /><br />I've got a question. I'm scripting against an existing postgresql database environment and need to tweakqueries based on the columns in the views or tables, how can if find these w/o querying the tables or views. <br /><br/>Currently I execute the querie and collect the columns but this is rather expensive, silly and fails when the tableor view is empty.<br /><br />-- <br />Met vriendelijke groeten/with kind regards<br /><br /> John van Zantvoort<br /><br />---<br />Most burning issues generate far more heat than light.<br /><br />-----BEGIN GEEK CODE BLOCK-----<br/>Version: 3.12<br />GCM d-- s:+ a C++ UL++++ P+++ L++ E--- W++ N+ o-- K- w<br />O M- V- PS+ PE- Y PGP++ t 5X R- tv- b+ DI+ D+ <br />G e h--- r++ y++<br />------END GEEK CODE BLOCK------
В списке pgsql-sql по дате отправления: