Tuesday, March 15, 2016

[google-cloud-sql-discuss] Re: Determine Columns & Data Types for Arbitrary Queries

Thank you for asking your question here.

If I understand your intent correctly, you would like to inspect the schema of the a result set from one query without writing it to a new table. Is this correct? If not, would you mind provided a slightly more concrete example?

On Wednesday, March 9, 2016 at 1:05:48 PM UTC-5, Joe Allan Muharsky wrote:
Good morning,

I'm working on a tool that supports arbitrary SQL statements against Cloud SQL data sources.  In particular, I'm looking for a method or library that will provide me with the "schema" for the result set (column names and data types).  This would be similar to executing a query INTO a new table, then inspecting the schema of the target table, but I'd like to avoid a temp table write.

Any help is appreciated.

Joe

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d2ea4cc0-efa4-4f8e-8efb-cb02685c232c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment