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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: can pgadmin prompt you for data to enter into query / exporter for Openoffice
Дата
Msg-id 03AF4E498C591348A42FC93DEA9661B866E3@salem.vale-housing.co.uk
обсуждение исходный текст
Ответ на can pgadmin prompt you for data to enter into query / exporter for Openoffice  ("George T. Gibson" <gtgibson@jbstamping.com>)
Список pgadmin-support

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

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Unable to Connect
Следующее
От: "Dave Page"
Дата:
Сообщение: pgAdmin 1.3.76