Sync your connections and queries to Navicat Cloud, or organize your work through a UI-enhanced multi-tasking workflow.
NAVICAT FOR POSTGRESQL BASIC UNDERSTANDING PORTABLE
Navicat has a whole new set of features aimed at making your database administration portable and at enhancing the classic Navicat experience. Whether you are working from an iPhone or an iPad, Navicat frees you from your workstation. Navicat for PostgreSQL is the first complete database administration tool developed for iOS, giving you the power to manage your databases on the go. I180905 20:57:16.669721 445 sql/conn_executor.go:1225 :49741,user=root] execution error: column "cl.***** Navicat Premium named “Best Database Administration Solution” by Database Trends and Applications Magazine ***** I180905 20:57:16.669571 445 sql/conn_executor.go:1052 :49741,user=root] executing ExecStmt: SELECT cl.column_name, ty.typtype, cl.udt_schema, ty.typname, cl.column_default FROM information_lumns AS cl LEFT JOIN pg_type AS ty ON ty.typname = cl.udt_name LEFT JOIN pg_namespace AS nsp ON nsp.oid = ty.typnamespace WHERE ((nsp.nspname = cl.udt_schema) AND (cl.table_schema = 'public')) AND (cl.table_name = 'a') I180905 20:57:16.669499 445 sql/conn_executor.go:1052 :49741,user=root] executing ExecStmt: SELECT cl.column_name, ty.typtype, cl.udt_schema, ty.typname, cl.column_default FROM information_lumns AS cl LEFT JOIN pg_type AS ty ON ty.typname = cl.udt_name LEFT JOIN pg_namespace AS nsp ON nsp.oid = ty.typnamespace WHERE ((nsp.nspname = cl.udt_schema) AND (cl.table_schema = 'public')) AND (cl.table_name = 'a') I180905 20:57:16.667567 445 sql/conn_executor.go:1052 :49741,user=root] executing ExecStmt: SELECT attname AS name, attrelid AS tid, COALESCE((SELECT attnum = ANY (conkey) FROM pg_constraint WHERE (contype = 'p') AND (conrelid = attrelid)), false) AS primarykey, NOT (attnotnull) AS allownull, (SELECT seq.oid FROM pg_class AS seq LEFT JOIN pg_depend AS dep ON seq.oid = dep.objid WHERE ((seq.relkind = 'S'::CHAR) AND (dep.refobjsubid = attnum)) AND (dep.refobjid = attrelid)) IS NOT NULL AS autoincrement FROM pg_attribute WHERE ((attisdropped = false) AND (attrelid = (SELECT tbl.oid FROM pg_class AS tbl LEFT JOIN pg_namespace AS sch ON tbl.relnamespace = sch.oid WHERE ((tbl.relkind = 'r'::"char") AND (tbl.relname = 'a')) AND (sch.nspname = 'public')))) AND (attname = 'a')
I180905 20:57:16.667506 445 sql/conn_executor.go:1052 :49741,user=root] executing ExecStmt: SELECT attname AS name, attrelid AS tid, COALESCE((SELECT attnum = ANY (conkey) FROM pg_constraint WHERE (contype = 'p') AND (conrelid = attrelid)), false) AS primarykey, NOT (attnotnull) AS allownull, (SELECT seq.oid FROM pg_class AS seq LEFT JOIN pg_depend AS dep ON seq.oid = dep.objid WHERE ((seq.relkind = 'S'::CHAR) AND (dep.refobjsubid = attnum)) AND (dep.refobjid = attrelid)) IS NOT NULL AS autoincrement FROM pg_attribute WHERE ((attisdropped = false) AND (attrelid = (SELECT tbl.oid FROM pg_class AS tbl LEFT JOIN pg_namespace AS sch ON tbl.relnamespace = sch.oid WHERE ((tbl.relkind = 'r'::"char") AND (tbl.relname = 'a')) AND (sch.nspname = 'public')))) AND (attname = 'a') SELECT c.oid, obj_description(c.oid), c.relhasoids AS hasoids, n.nspname AS schemaname, c.relname AS tablename, c.relkind, pg_get_userbyid(c.relowner) AS tableowner, t.spcname AS "tablespace", c.relhasindex AS hasindexes, c.relhasrules AS hasrules, c.relhastriggers AS hastriggers, ft.ftoptions, fs.srvname, c.relacl, c.reltuples, ((SELECT count(*) FROM pg_inherits WHERE inhparent = c.oid) > 0) AS inhtable, i2.nspname AS inhschemaname, i2.relname AS inhtablename, c.reloptions AS param, c.relpersistence AS unlogged FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace LEFT JOIN (pg_inherits i INNER JOIN pg_class c2 ON i.inhparent = c2.oid LEFT JOIN pg_namespace n2 ON n2.oid = c2.relnamespace) i2 ON i2.inhrelid = c.oid LEFT JOIN pg_foreign_table ft ON ft.ftrelid = c.oid LEFT JOIN pg_foreign_server fs ON ft.ftserver = fs.oid WHERE ((c.relkind = 'r'::"char") OR (c.relkind = 'f'::"char")) AND n.nspname = 'public'
SELECT nspname, oid, pg_get_userbyid(nspowner) AS owner, nspacl, obj_description(oid) FROM pg_namespace
0 kommentar(er)
