![]() ![]() Psql:describe_table.sql:38: NOTICE: type reference information_type%TYPE converted to information_schema.character_data Psql:describe_table.sql:37: NOTICE: type reference information_name%TYPE converted to information_schema.sql_identifier Psql:describe_table.sql:36: NOTICE: type reference information_position%TYPE converted to information_schema.cardinal_number Psql:describe_table.sql:35: NOTICE: type reference information_name%TYPE converted to information_schema.sql_identifier Psql:describe_table.sql:34: NOTICE: type reference information_schema%TYPE converted to information_schema.sql_identifier ![]() If you wrote a wrapper function that returned VARCHAR variables, you would probably get a result like this when you call your function: That’s because while you can query them like VARCHAR variables they don’t cast to variable length string. These specialized types are required because the SQL cursor gathers the information from the data dictionary in the information_schema, and most of these types can’t be cast as variable length strings.Ī simple assumption that the data dictionary strings would implicitly cast to variable length strings is incorrect. ![]() For example, the data types of the return parameter values of a function that returns values from the data dictionary are specific to types used by the data dictionary. There are a few techniques in the script that might seem new to some developers. So, I wrote a little function to let me display only the table and columns. Often, you only want to see the list of columns in positional order. Unfortunately, this shows you the table, indexes, and foreign key constraints. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |