Viewing the Current Schema in Greenplum

There may be times when you are not sure what schema you are currently in or what your search_path setting is. To find out this information, you can use the current_schema() function or the SHOW command. For example:

=> SELECT current_schema();
=> SHOW search_path;


Comments