reference-data-list-postgresql.xql
DB Query file
Related Files
- packages/acs-reference/www/reference-data-list.tcl
- packages/acs-reference/www/reference-data-list.adp
- packages/acs-reference/www/reference-data-list-postgresql.xql
- packages/acs-reference/www/reference-data-list-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="data_select"> <querytext> select repository_id, table_name, internal_data_p, package_name, to_char(last_update,'MM-DD-YYYY') as updated, source, source_url, effective_date, expiry_date from acs_reference_repositories a order by table_name </querytext> </fullquery> </queryset>