On 08/02/2013 03:31 PM, Jean MAURICE wrote:
> Hi Tovo,
>
> I saw there is a view 'tables' that gives the list of the tables. How do
> we use a view in Postgres ?
> I tried
> SELECT * FROM tables;
> but the error is something like 'the relation 'tables' doesn't exist'
> (my Postgres is in French !)
>
> Best regards
>
It's quite simple, for example, if you want to list tables by using the
view tables, you make the following query :
SELECT * FROM information_schema.tables
Et voilà