DB URL syntax with table level specificity?

A JDBC URL generally addresses a database. I need a unique abstract
address for individual tables in a database. What I'm proposing to do
is to append something onto the database URL (and, obviously, strip it
off again at the appropriate moment). My current idea is to put the
table name into the query part of the URL, so that if you have a
database URL of the form

jdbc:postgresql://datahost:5432/mydatabase

the URL for the table called 'mytable' in that database would be

jdbc:postgresql://datahost:5432/mydatabase?table=mytable

With Microsoft-style URLs this would become

jdbc:microsoft:sqlserver://my.server:1433;DatabaseName=MYDB;SelectMethod=cursor;ProgamName=myprogram;table=mytable

so that the general rule is, when appending, if there is no question
mark ('?'), ampersand( '&') or semi-colon ( ';') in the string
representation I'll append a question mark followed by the token
'table' followed by an equality sign ('=') followed by the table name,
and when parsing I'll tokenise the URL on the characters ('?&;') to
recover my fragment.

So, two questions: firstly, am I reinventing a wheel?

And secondly, can anyone think of a reason why this should not work?

--
simon@xxxxxxxxxxxxxx (Simon Brooke) http://www.jasmine.org.uk/~simon/

The Conservative Party is now dead. The corpse may still be
twitching, but resurrection is not an option - unless Satan
chucks them out of Hell as too objectionable even for him.

.

Relevant Pages

  • Re: Parameter dialog box pops up
    ... > I need to update my Access database from an Excel list. ... The question is how do I append each field from ... > append query for each table from my TableN and run them separately). ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)
  • Re: Populating Databse
    ... that wasn't an Access database for sure! ... Same with SSN and so on. ... you can use the Append query; ... to append some clearly unreasonable date into the datefield (which you ...
    (microsoft.public.access.tablesdbdesign)
  • Re: [OT] PostgreSQL: bytea help needed.
    ... >> Well, you draw the data in, and then append it to the field. ... > the database from my local filesystem for example. ... > Well I wanted to grab binary data off my filesystem directly from the ... > COPY command which is used to pull text data in. ...
    (comp.os.linux.misc)
  • Re: Possible Project Bug: All Projects in Database are Deleted upon Save
    ... prompts with Append or overwrite message. ... best practices and Project VBA ... > DELETION of the current database. ... I understand that there is an option with the DisplayAlerts ...
    (microsoft.public.project.vba)