From: Hanan Hotmail <h_harush@hotmail.com>
To: pgsql <pgsql-sql@postgresql.org>
Subject: Design question: How to convert a given data structure to sql and the opposite.
Date: Sat, 8 Feb 2003 18:23:57 +0200
Message-ID: <DAV49XuGPETXd4Fm5Oe00001ab5@hotmail.com> (raw)
Hi,
Configuration:
I'm using postgresql 7.3 on Linux box ( RH 7.3) from Perl DBI module.
The problem:
I'm implementing a very interesting system where i need to enable via user
interface (WEB GUI ) to build/update and execute SQL queries on my DB
scheme.
1. I need to translate a given data structure to SQL query .
2. I need to load SQL query to memory.
Generaly i need to convert from a given data structure to sql and the
opposite which means i want to represent a generic SQL in terms and i want
to be able to
load saved query and execute it.
Just to make things clear i will detail to scenarios:
1 . A User => Creates a query using GUI => he/she can execute the query
2. A query is stored somehow => The user update the query according to his
needs => the user save the query and then execute it.
Any idea/direction will be welcome ?
Hanan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: h_harush@hotmail.com
Subject: Re: Design question: How to convert a given data structure to sql and the opposite.
In-Reply-To: <DAV49XuGPETXd4Fm5Oe00001ab5@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox