Hi all,
Is there any way, to know the name of indexes on a table, defined in
a database. I mean can I query something like
Select Index_name from pg_class where relname = Table_name .
Thanks in advance.
--- Thanks Reagrds
Anirban Pal | Software Engineer
Newgen Software
On Jun 13, 2009, at 12:35 AM, Christine Penner wrote:
Sam,
The problem with making it a numeric field is that I have seen
things like A123, #123a or 23-233. This is only here to make most
sorting work better, not perfect. It all depends on how they enter
the data. Wont the different
On Jun 13, 2009, at 1:52 AM, Brad Schick wrote:
After a new pgsql installation the postgres maintenance database has
an encoding of SQL_ASCII. pgAdmin III gave me a warning about that,
and
I may want to create users or databases that are not restricted 7bit
ASCII.
SQL_ASCII 7 bit ASCII.
On Jun 12, 2009, at 11:53 AM, Yaroslav Tykhiy wrote:
I cannot but ask the community a related question here: Can such
design, that is, storing quite large objects of varying size in a
PostgreSQL database, be a good idea in the first place? I used to
believe that what RDBMS were really
Michael Glaesemann g...@seespotcode.net writes:
I'd like to be able to access individual elements of anyarray,
treating them as type anyelement to take advantage of the
polymorphism. Using pg_stats.histogram_bounds as a convenient example
of an anyelement array, here's an example of the