--- "Luiz K. Matsumura" <[EMAIL PROTECTED]> wrote:
> Ugh, I'm totally crazy with this views
> I'm using pgadmin with postgres, when I clink on "view the data of
> selected object" button all works fine.
> But when I open a query tool window and do:
>
> SELECT * FROM view1;
> Now, again type1 column returns as bpchar.
> But if I do:
This might be a good question to ask on the PGAdmin mailing list or even try
using the latest
version of PGAdmin. Perhaps this is something that PGAdmin is doing rather
than postgresql.
If you open psql -U your_db_user -d your_database_name.
and type:
\d schema_name.view_name
was does it show as the definition of the column.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
