Re: Cast on character columns in views
От | Richard Broersma Jr |
---|---|
Тема | Re: Cast on character columns in views |
Дата | |
Msg-id | 108933.2667.qm@web31807.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Re: Cast on character columns in views ("Luiz K. Matsumura" <luiz@planit.com.br>) |
Ответы |
Re: Cast on character columns in views
|
Список | pgsql-sql |
--- "Luiz K. Matsumura" <luiz@planit.com.br> 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.
В списке pgsql-sql по дате отправления: