Menu
▾
▴
[pgsqlclient-checkins] SF.net SVN: pgsqlclient: [24] pgsqlclient/source/PostgreSql/Data/Schema/TextFile1.txt
|
From: <car...@us...> - 2006-03-13 21:49:28
|
Revision: 24 Author: carlosga_fb Date: 2006-03-13 13:49:23 -0800 (Mon, 13 Mar 2006) ViewCVS: http://svn.sourceforge.net/pgsqlclient/?rev=24&view=rev Log Message: ----------- Removed Paths: ------------- pgsqlclient/source/PostgreSql/Data/Schema/TextFile1.txt Deleted: pgsqlclient/source/PostgreSql/Data/Schema/TextFile1.txt =================================================================== --- pgsqlclient/source/PostgreSql/Data/Schema/TextFile1.txt 2006-03-13 21:45:11 UTC (rev 23) +++ pgsqlclient/source/PostgreSql/Data/Schema/TextFile1.txt 2006-03-13 21:49:23 UTC (rev 24) @@ -1,12 +0,0 @@ -checkconstraints :: SELECT pg_namespace.nspname AS CONSTRAINT_SCHEMA, pg_constraint.conname AS CONSTRAINT_NAME, pg_get_constraintdef(pg_constraint.oid) AS CHECK_CLAUSULE, pg_description.description AS DESCRIPTION FROM pg_constraint left join pg_namespace ON pg_constraint.connamespace = pg_namespace.oid left join pg_description ON pg_constraint.oid = pg_description.objoid WHERE pg_constraint.contype = 'c' ORDER BY pg_namespace.nspname, pg_constraint.conname -checkconstraintsbytable :: SELECT pg_namespace.nspname AS CONSTRAINT_SCHEMA, pg_constraint.conname AS CONSTRAINT_NAME, tbn.nspname AS TABLE_SCHEMA, pg_class.relname AS TABLE_NAME, pg_get_constraintdef(pg_constraint.oid) AS CHECK_CLAUSULE, pg_description.description AS DESCRIPTION FROM pg_constraint left join pg_class ON pg_class.oid = pg_constraint.conrelid left join pg_namespace tbn ON pg_class.relnamespace = tbn.oid left join pg_namespace ON pg_constraint.connamespace = pg_namespace.oid left join pg_description ON pg_constraint.oid = pg_description.objoid WHERE pg_constraint.contype = 'c' AND pg_class.relkind = 'r' ORDER BY pg_namespace.nspname, pg_class.relname, pg_constraint.conname -domains :: SELECT pg_namespace.nspname AS DOMAIN_SCHEMA, pg_type.typname AS DOMAIN_NAME, pg_type.oid AS DATA_TYPE, pg_type.typlen AS COLUMN_SIZE, pg_type.typnotnull AS IS_NOT_NULL, pg_type.typndims AS ARRAY_DIMENSIONS, pg_type.typelem AS ELEMENT_TYPE, pg_type.typbasetype AS BASE_TYPE, pg_type.typtypmod AS BASE_TYPE_MODIFIER, pg_description.description AS DESCRIPTION FROM pg_type left join pg_namespace ON pg_type.typnamespace = pg_namespace.oid left join pg_description ON pg_type.oid = pg_description.objoid WHERE pg_type.typtype = 'd' ORDER BY pg_namespace.nspname, pg_type.typname -foreignkeys :: SELECT pg_namespace.nspname AS PK_TABLE_SCHEMA, pk_table.relname AS PK_TABLE_NAME, pg_namespace.nspname AS FK_TABLE_SCHEMA, fk_table.relname AS FK_TABLE_NAME, pg_constraint.conkey AS PK_COLUMNS, pg_constraint.confkey AS FK_COLUMNS, case pg_constraint.confupdtype when 'a' THEN 'NO ACTION' when 'r' THEN 'RESTRICT' when 'c' THEN 'CASCADE' when 'd' THEN 'SET DEFAULT' when 'n' THEN 'SET NULL' END AS UPDATE_RULE, case pg_constraint.confdeltype when 'a' THEN 'NO ACTION' when 'r' THEN 'RESTRICT' when 'c' THEN 'CASCADE' when 'd' THEN 'SET DEFAULT' when 'n' THEN 'SET NULL' END AS DELETE_RULE, pg_constraint.conname AS FK_NAME, pg_constraint.condeferrable AS DEFERRABILITY, pg_constraint.condeferred AS IS_DEFERRED, pg_description.description AS DESCRIPTION FROM pg_constraint left join pg_namespace ON pg_constraint.connamespace = pg_namespace.oid left join pg_class as pk_table ON pg_constraint.conrelid = pk_table.oid right join pg_class as fk_table ON pg_constraint.confrelid = fk_table.oid left join pg_description ON pg_constraint.oid = pg_description.objoid WHERE pg_constraint.contype = 'f' ORDER BY pg_namespace.nspname, pk_table.relname, pg_constraint.conname -indexes :: SELECT pg_namespace.nspname AS TABLE_SCHEMA, pg_class.relname AS TABLE_NAME, pg_classidx.relname AS INDEX_NAME, Pgnamespidx.nspname AS INDEX_SCHEMA, pg_am.amname AS TYPE, pg_index.indkey AS INDEX_KEY, pg_index.indisclustered AS CLUSTERED, pg_index.indisunique AS UNIQUE, pg_index.indisprimary AS PRIMARY, pg_am.amindexnulls AS ALLOW_NULLS, pg_am.amcanmulticol AS MULTICOLUMN, pg_am.amconcurrent AS CONCURRENT, pg_description.description AS DESCRIPTION FROM pg_index left join pg_class ON pg_index.indrelid = pg_class.oid left join pg_class as pg_classidx ON pg_index.indexrelid = pg_classidx.oid left join pg_namespace ON pg_classidx.relnamespace = pg_namespace.oid left join pg_namespace as Pgnamespidx ON pg_classidx.relnamespace = Pgnamespidx.oid left join pg_am ON pg_classidx.relam = pg_am.oid left join pg_description ON pg_index.indexrelid = pg_description.objoid ORDER BY pg_namespace.nspname, pg_class.relname, pg_classidx.relname -functionprivileges :: SELECT pg_namespace.nspname AS FUNCTION_SCHEMA, pg_proc.proname AS FUNCTION_NAME, pg_proc.proacl AS PRIVILEGES FROM pg_proc left join pg_namespace ON pg_proc.pronamespace = pg_namespace.oid ORDER BY pg_namespace.nspname, pg_proc.proname -functions :: SELECT pg_namespace.nspname AS FUNCTION_SCHEMA, pg_proc.proname AS FUNCTION_NAME, pg_language.lanname AS PROCEDURE_LANGUAGE, pg_proc.proisagg AS IS_AGGREGATE, pg_proc.prosecdef AS IS_SECURITY_DEFINER, pg_proc.proisstrict AS IS_STRICT, case pg_proc.provolatile when 'i' THEN 'INMUTABLE' when 's' THEN 'STABLE' when 'v' THEN 'VOLATILE' END AS VOLATILE, pg_proc.proretset AS RETURNS_SET, pg_proc.prorettype AS RETURN_TYPE, pg_proc.pronargs AS ARGUMENT_NUMBER, pg_proc.proargtypes AS ARGUMENTS, pg_proc.prosrc AS SOURCE, pg_description.description AS DESCRIPTION FROM pg_proc left join pg_namespace ON pg_proc.pronamespace = pg_namespace.oid left join pg_language ON pg_proc.prolang = pg_language.oid left join pg_description ON pg_proc.oid = pg_description.objoid ORDER BY pg_namespace.nspname, pg_proc.proname -tableconstraint :: SELECT pg_schemacon.nspname AS CONSTRAINT_SCHEMA, pg_constraint.conname AS CONSTRAINT_NAME, pg_namespace.nspname AS TABLE_SCHEMA, pg_class.relname AS TABLE_NAME, case pg_constraint.contype when 'u' THEN 'UNIQUE' when 'p' THEN 'PRIMARY KEY' when 'f' THEN 'FOREIGN KEY' when 'c' THEN 'CHECK' END AS CONSTRAINT_TYPE, pg_constraint.condeferrable AS IS_DEFERRABLE, pg_constraint.condeferred AS INITIALLY_DEFERRED, pg_description.description AS DESCRIPTION FROM pg_constraint left join pg_class ON pg_class.oid = pg_constraint.conrelid left join pg_namespace ON pg_class.relnamespace = pg_namespace.oid left join pg_namespace as pg_schemacon ON pg_constraint.connamespace = pg_schemacon.oid left join pg_description ON pg_constraint.oid = pg_description.objoid ORDER BY pg_schemacon.nspname, pg_class.relname, pg_constraint.conname -tableprivileges :: SELECT pg_namespace.nspname AS TABLE_SCHEMA, pg_class.relname AS TABLE_NAME, pg_class.relacl AS PRIVILEGES FROM pg_class left join pg_namespace ON pg_class.relnamespace = pg_namespace.oid WHERE pg_class.relkind = 'r' ORDER BY pg_namespace.nspname, pg_class.relname -triggers :: SELECT pg_namespace.nspname AS TRIGGER_SCHEMA, pg_proc.proname AS TRIGGER_NAME, pg_class.relnamespace AS TABLE_SCHEMA, pg_class.relname AS TABLE_NAME, pg_language.lanname AS PROCEDURE_LANGUAGE, pg_proc.proisagg AS IS_AGGREGATE, pg_proc.prosecdef AS IS_SECURITY_DEFINER, pg_proc.proisstrict AS IS_STRICT, pg_proc.proretset AS RETURNS_SET FROM pg_trigger left join pg_class ON pg_trigger.tgconstrrelid = pg_class.oid left join pg_proc ON pg_trigger.tgfoid = pg_proc.oid left join pg_namespace ON pg_proc.pronamespace = pg_namespace.oid left join pg_language ON pg_proc.prolang = pg_language.oid ORDER BY pg_namespace.nspname, pg_proc.proname -views :: SELECT pg_namespace.nspname AS VIEW_SCHEMA, pg_class.relname AS VIEW_NAME, pg_get_ruledef(pg_rewrite.oid) AS DEFINITION, pg_description.description AS DESCRIPTION FROM pg_class left join pg_namespace ON pg_class.relnamespace = pg_namespace.oid left join pg_rewrite ON pg_class.oid = pg_rewrite.ev_class left join pg_description ON pg_class.oid = pg_description.objoid WHERE pg_class.relkind = 'v' ORDER BY pg_namespace.nspname, pg_class.relname -viewprivileges :: SELECT pg_namespace.nspname AS VIEW_SCHEMA, pg_class.relname AS VIEW_NAME, pg_class.relacl AS PRIVILEGES FROM pg_class left join pg_namespace ON pg_class.relnamespace = pg_namespace.oid left join pg_rewrite ON pg_class.oid = pg_rewrite.ev_class WHERE pg_class.relkind = 'v' ORDER BY pg_namespace.nspname, pg_class.relname This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
