Re: View String or Representation

From: Gregory Seidman <gss+pg(at)cs(dot)brown(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: View String or Representation
Date: 2002-06-11 16:11:49
Message-ID: 20020611161149.GA5923@cs.brown.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2002-06-11 16:24:41 Re: View String or Representation
Previous Message SERFIOTIs gewrgios 2002-06-11 15:55:24 View String or Representation

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Marlowe 2002-06-11 16:24:41 Re: View String or Representation
Previous Message SERFIOTIs gewrgios 2002-06-11 15:55:24 View String or Representation