pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedScan SQL
5+ messages / 5 participants
[nested] [flat]
* Scan SQL
@ 2002-07-23 13:11 Sandro Joel Eller <sandro@tecsoft.com.br>
2002-07-23 15:40 ` Re: Scan SQL Josh Berkus <josh@agliodbs.com>
2002-07-23 17:36 ` Re: Scan SQL Roberto Mello <rmello@cc.usu.edu>
0 siblings, 2 replies; 5+ messages in thread
From: Sandro Joel Eller @ 2002-07-23 13:11 UTC (permalink / raw)
To: pgsql-sql
Hi
I need to make a parser in a sql to get tables and fields to verify the
privileges. Do anybody know software, function or anything that can help me?
I found software to create a compiler and generate the source in delphi, but I
need a sql specification (BNF, EBNF) and I do not know where to find it.
Thanks
Sandro
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Scan SQL
2002-07-23 13:11 Scan SQL Sandro Joel Eller <sandro@tecsoft.com.br>
@ 2002-07-23 15:40 ` Josh Berkus <josh@agliodbs.com>
2002-07-23 14:34 ` Re: Scan SQL Sandro Joel Eller <sandro@koerich.com.br>
1 sibling, 1 reply; 5+ messages in thread
From: Josh Berkus @ 2002-07-23 15:40 UTC (permalink / raw)
To: Sandro Joel Eller <sandro@tecsoft.com.br>; pgsql-sql
Sandro,
> I need to make a parser in a sql to get tables and fields to verify
> the
> privileges. Do anybody know software, function or anything that can
> help me?
I probably can, but I'm not quite sure what you're asking for. Could
you explain at greater length, maybe with some examples?
-Josh Berkus
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Scan SQL
2002-07-23 13:11 Scan SQL Sandro Joel Eller <sandro@tecsoft.com.br>
2002-07-23 15:40 ` Re: Scan SQL Josh Berkus <josh@agliodbs.com>
@ 2002-07-23 14:34 ` Sandro Joel Eller <sandro@koerich.com.br>
0 siblings, 0 replies; 5+ messages in thread
From: Sandro Joel Eller @ 2002-07-23 14:34 UTC (permalink / raw)
To: pgsql-sql
Josh
The good, will be, see the sample below, return field list and table list of
the sql and to analyse it to give permission or not to open the table in
delphi.
select a, b, c, d from z, x
Sandro
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "Sandro Joel Eller" <sandro@tecsoft.com.br>; <pgsql-sql@postgresql.org>
Sent: Tuesday, July 23, 2002 3:40 PM
Subject: Re: [SQL] Scan SQL
> Sandro,
>
> > I need to make a parser in a sql to get tables and fields to verify
> > the
> > privileges. Do anybody know software, function or anything that can
> > help me?
>
> I probably can, but I'm not quite sure what you're asking for. Could
> you explain at greater length, maybe with some examples?
>
> -Josh Berkus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Scan SQL
2002-07-23 13:11 Scan SQL Sandro Joel Eller <sandro@tecsoft.com.br>
@ 2002-07-23 17:36 ` Roberto Mello <rmello@cc.usu.edu>
2002-07-23 22:18 ` Re: Scan SQL Josh Jore <josh@greentechnologist.org>
1 sibling, 1 reply; 5+ messages in thread
From: Roberto Mello @ 2002-07-23 17:36 UTC (permalink / raw)
To: Sandro Joel Eller <sandro@tecsoft.com.br>; +Cc: pgsql-sql
On Tue, Jul 23, 2002 at 10:11:18AM -0300, Sandro Joel Eller wrote:
> Hi
>
> I need to make a parser in a sql to get tables and fields to verify the
> privileges. Do anybody know software, function or anything that can help me?
>
> I found software to create a compiler and generate the source in delphi, but I
> need a sql specification (BNF, EBNF) and I do not know where to find it.
You could look at how PostgreSQL does its parsing. The source code is
open.
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
I to¤d yo¤, "Never¤touch ¤he flo¤py di¤k su¤face!"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Scan SQL
2002-07-23 13:11 Scan SQL Sandro Joel Eller <sandro@tecsoft.com.br>
2002-07-23 17:36 ` Re: Scan SQL Roberto Mello <rmello@cc.usu.edu>
@ 2002-07-23 22:18 ` Josh Jore <josh@greentechnologist.org>
0 siblings, 0 replies; 5+ messages in thread
From: Josh Jore @ 2002-07-23 22:18 UTC (permalink / raw)
To: ; +Cc: Sandro Joel Eller <sandro@tecsoft.com.br>; pgsql-sql
On Tue, 23 Jul 2002, Roberto Mello wrote:
> On Tue, Jul 23, 2002 at 10:11:18AM -0300, Sandro Joel Eller wrote:
> > Hi
> >
> > I need to make a parser in a sql to get tables and fields to verify the
> > privileges. Do anybody know software, function or anything that can help me?
> >
> > I found software to create a compiler and generate the source in delphi, but I
> > need a sql specification (BNF, EBNF) and I do not know where to find it.
>
> You could look at how PostgreSQL does its parsing. The source code is
> open.
>
> -Roberto
Check out src/backend/parser/*.y for full YACC grammars.
Joshua b. Jore ; http://www.greentechnologist.org
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-07-23 22:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-23 13:11 Scan SQL Sandro Joel Eller <sandro@tecsoft.com.br>
2002-07-23 15:40 ` Josh Berkus <josh@agliodbs.com>
2002-07-23 14:34 ` Sandro Joel Eller <sandro@koerich.com.br>
2002-07-23 17:36 ` Roberto Mello <rmello@cc.usu.edu>
2002-07-23 22:18 ` Josh Jore <josh@greentechnologist.org>
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