Thread: 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.

Also, has anyone written an exporter for OpenOffice Calc?

Thanks for the help.

--
J.B. Stamping, Inc.
George Gibson
7413 Associate Ave.
Cleveland, OH 44144
216.631.0013  216.631.1327 fax
gtgibson@jbstamping.com

> -----Original Message-----
> From: George T. Gibson [mailto:gtgibson@jbstamping.com]
> Sent: 16 August 2002 22:35
> To: pgadmin-support@postgresql.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.