From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Luiz K. Matsumura <luiz@planit.com.br>
To: pgsql-sql@postgresql.org
Subject: Re: Cast on character columns in views
Date: Tue, 4 Sep 2007 04:08:47 -0700 (PDT)
Message-ID: <108933.2667.qm@web31807.mail.mud.yahoo.com> (raw)
In-Reply-To: <46DD0A5E.9010400@planit.com.br>
--- "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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, luiz@planit.com.br
Subject: Re: Cast on character columns in views
In-Reply-To: <108933.2667.qm@web31807.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox