`
wwbutton
  • 浏览: 41688 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

PostgreSQL View Table Info

阅读更多
SELECT * FROM pg_attribute WHERE attrelid = ‘tablename’::regclass;
–只查看字段名
SELECT attname FROM pg_attribute WHERE attrelid = ‘tablename’::regclass;
分享到:
评论

相关推荐

    PostgreSQL物化视图(materialized view)过程解析

    这篇文章主要介绍了PostgreSQL物化视图(materialized view)过程解析,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下 1、创建视图 CREATE MATERIALIZED VIEW ...

    《SQL数据库管理工具》(Richardson Software RazorSQL)v5.1.1/含注册机

    * Database Data Search tool for searching single or multiple database table and view data. * Database Object Search tool for searching for database objects. * Backup tools such as the Database Backup ...

    pg_schema_triggers:PostgreSQL 9.3+模式触发器扩展

    pg_schema_triggers 0.1 此扩展将架构更改事件添加到... Event Name Description-------------------- ----------------------------------------------------relation_create New relation (table, view, or in

    SQL Assistant v5.0

    Code refactoring - Rename table/view column view in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename ...

    PremiumSoft Navicat Premium Enterprise v11.2.13 (x86 & x64)

    SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc. Navicat Premium enables you to easily and quickly transfer data across various database ...

    Rails, Angular, Postgres, and Bootstrap(Pragmatic,2016)

    Create a usable and attractive login form using Bootstrap’s styles, while ensuring the database table backing it is secure, using Postgres’ check constraints. You’ll see how creating an advanced ...

    Navicat 11.2.12 Premium x64

    Navicat Premium combines the functions of other Navicat members and supports most of the features in MySQL, SQL Server, SQLite, Oracle and PostgreSQL including Stored Procedure...

    SQL必知必会(第3版 中文高清版)

     b.12 使用postgresql   b.13 使用query tool   b.14 使用sybase   b.15 配置odbc数据源  附录c sql语句的语法   c.1 alter table   c.2 commit   c.3 create index   c.4 create ...

    Django.Unleashed.0321985079.epub

    Deploy your site to a managed cloud service and to a PostgreSQL database Table of Contents Part I Django’s Core Features Chapter 1 Starting a New Django Project: Building a Startup Categorizer with ...

    Rails.Angular.Postgres.and.Bootstrap.2nd.Edition

    With this fully revised new edition, take a holistic view of full-stack development to create usable, high-performing applications with Rails 5. Rails is a great tool for building web applications, ...

    sqlmap (懂的入)

    * Full support for MySQL, Oracle, PostgreSQL and Microsoft SQL Server database management system back-end. Besides these four DBMS, sqlmap can also identify Microsoft Access, DB2, Informix and ...

    SqliteDev 384

    同时能够跟很多程序语言相结合 比如 Tcl C# PHP Java等 还有ODBC接口 同样比起Mysql PostgreSQL这两款开源世界著名的数据库管理系统来讲 它的处理速度比他们都快 SQLite第一个Alpha版本诞生于2000年5月 至今已经有10...

    SQLite(SqliteDev)

    它能够支持Windows/Linux/Unix等等主流的操作系统,同时能够跟很多程序语言相结合,比如 Tcl、C#、PHP、Java等,还有ODBC接口,同样比起Mysql、PostgreSQL这两款开源世界著名的数据库管理系统来讲,它的处理速度比...

    NBEARLISY使用

    1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool. 2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation system's could not ...

    oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 连接字符串

    PostgreSQL 号称“世界上最先进的开源数据库“,可以运行在多种平台下,是tb级数据库,而且性能也很好 中大型企业 oracle 甲骨文 获得最高认证级别的ISO标准安全认证,性能最高, 保持开放平台下的TPC-D和TPC-C的...

    flinkStreamSQL

    自定义create table 语法(包括源表,输出表,维表) 自定义create view 语法 自定义create function 语法 实现了流与维表的join 支持原生FLinkSQL所有的语法 扩展了输入和输出的性能指标到promethus 新特性: 1.kafka...

    SQL必知必会(第3版)--详细书签版

    C.6 CREATE VIEW 168 C.7 DELETE 169 C.8 DROP 169 C.9 INSERT 169 C.10 INSERT SELECT 169 C.11 ROLLBACK 169 C.12 SELECT 170 C.13 UPDATE 170 附录D SQL数据类型 171 D.1 串数据类型 172 D.2 数值数据...

    数据库系统概念Database System Concept(英文第6版)文字版

    1.3 View of Data 6 1.4 Database Languages 9 1.5 Relational Databases 12 1.6 Database Design 15 1.7 Data Storage and Querying 20 1.8 Transaction Management 22 1.9 Database Architecture 23 1.10 Data ...

    SQL必知必会(第3版-PDF清晰版)part1

    B.12 使用PostgreSQL... 164 B.13 使用Query Tool. 164 B.14 使用Sybase.. 165 B.15 配置ODBC数据源..... 165 附录C SQL语句的语法...... 167 C.1 ALTER TABLE... 167 C.2 COMMIT... 167 C.3 CREATE INDEX... 168 C...

Global site tag (gtag.js) - Google Analytics