Hi,
In Oracle there are instances when as a developer I know how the data
is spread in the tables and I want to be sure the database uses the
right index. Does the following hold true in Postgresql for a query
like this:
select s.order_id
from small_orders_table s, orders o
where s.find_these_id
Hi,
I have an application using Postgresql with a large (100+) number of
tables. Are there any free/open source tools that can ease the process
of updating the schema.
Specifically I would like to compare a source and a target, determine
the differences and the best way to update the target to
On the one hand I like how the schema scripts fail when there is a
single problem with a DDL statement.
On the other hand sometimes it is a pain - especially to take out all
the 'drop sequence', 'drop table' etc commands when creating a new
database.
Is there a 'drop if doesnt exist' or a better
Hi,
What query can I run to get the comments for my table columns.
i.e. the ones on my 8.1 database added with this command:
COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the
addresses table';
thanks
Tim
---(end of broadcast)---
haracter varying::text = sfl.column_name::text
> WHERE pa.attnum > 0
> ORDER BY pc.relname::character varying, pa.attnum;
>
> "Timasmith" <[EMAIL PROTECTED]> wrote in message
>
> news:[EMAIL PROTECTED]
>
>
>
> > Hi,
>
> > What query can I
I am using hibernate, using a view like a read only table and I need a
primary key each time a select is issued.
So in Oracle terms this might work, though I am skeptical that
Hibernate is going to return a cached result.
create view myview as
select rownum, t1.field, t2.field
from tableOne t1, t
On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote:
> On Thu, Mar 01, 2007 at 06:16:02 -0800,
> Timasmith<[EMAIL PROTECTED]> wrote:
>
> > I am using hibernate, using a view like a read only table and I need a
> > primary key each time a select is issued.
On Mar 5, 3:35 am, [EMAIL PROTECTED] (Bruno Wolff III) wrote:
> On Sat, Mar 03, 2007 at 16:46:45 -0800,
> Timasmith<[EMAIL PROTECTED]> wrote:
>
> > On Mar 3, 7:12 pm, [EMAIL PROTECTED] (Bruno Wolff III) wrote:
> > > On Thu, Mar 01, 2007 at 06:16:02 -0800,
> > &
Suppose I have a database table with 20 fields which are lookups to a
single table.
configtable(configtable_id, a_field, something_lookup_id,
another_lookup_id, ...)
lookup(lookup_id, value, description, ...)
what is going to be faster to map the rows to an Object which needs
the 'value' for eve
On Mar 8, 2:26 pm, [EMAIL PROTECTED] (Shane Ambler) wrote:
> Timasmithwrote:
> > Suppose I have a database table with 20 fields which are lookups to a
> > single table.
>
> > configtable(configtable_id, a_field, something_lookup_id,
> > another_lookup_id, ...)
> > lookup(lookup_id, value, descripti
Hi,
I have a program which uses Postgresql as a database for persistence.
The application uses IzPack to install.
Ideally I would like to also install Postgresql in the same wizard
conversation, plus get it up and running as a windows service (or
daemon on 'nix).
Is all of that possible - has an
11 matches
Mail list logo