Re: View String or Representation

Thanks,
    I have read about this option, but i need to access the view definition
through JDBC, so i need a 'SELECT' statement that can be executed by JDBC.

George.

On Tue, 11 Jun 2002, Gregory Seidman wrote:

> SERFIOTIs gewrgios sez:
> }     does anyone know when I create a view where does Postgresql
> } store the string with the view definition or any other internal
> } representation of the view?
> }
> } I have looked up for the question in two Postgresql manual without finding
> } an answer!
>
> If you use psql, you can type \d <viewname> to get the definition of the
> view. If you start psql with the -E and type that you will see the SQL that
> psql is invoking to find the information, including the reference to the
> pg_views system table.
>
> } Thank you,
> } George.
> --Greg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>