Re: can pgadmin prompt you for data to enter into query / exporter for Openoffice

> -----Original Message-----
> From: George T. Gibson [mailto:gtgibson(at)jbstamping(dot)com]
> Sent: 16 August 2002 22:35
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] can pgadmin prompt you for data to
> enter into query / exporter for Openoffice
>
>
> Is it possible to have pgadmin ask you for a value when
> performing a query similar to how MSAccess does?
>
> For example, I want to have a query where I can see shipments
> between two dates. I do not want to hardcode the dates in -
> I would like to enter them each time I execute the query.
>
> select * from shipments where shipments.date > [Enter
> beginning date] and shipments.date < [Enter end date];
>
> I'm not sure if this is something that would be supported
> directly in Postgres or if it requires an external program
> like pgAdmin or Access.

This would need to be written in pgAdmin as that is what you would
interact with. I'll look into it.

> Also, has anyone written an exporter for OpenOffice Calc?

Not to my knowledge. At the moment, probably the best solution would be
to export to ASCII text then import that.

Regards, Dave.