Show tables describe tables equivalent in redshift

Question

I m new to aws  can anyone tell me what are redshifts  equivalents to mysql commands   show tables -- redshift command describe table name -- redshift command

User · Answer

Or simply    dt to show tables   d   lt table name gt  to describe a table   Edit  Works using the psql command line client

User · Answer

In the following post  I documented queries to retrieve TABLE and COLUMN comments from Redshift   https   sqlsylvia wordpress com 2017 04 29 redshift-comment-views-documenting-data   Enjoy   Table Comments      SELECT n nspname AS schema name        pg get userbyid c relowner  AS table owner        c relname AS table name        CASE WHEN c relkind    v  THEN  view  ELSE  table  END         AS table type        d description AS table description      FROM pg class As c      LEFT JOIN pg namespace n ON n oid   c relnamespace      LEFT JOIN pg tablespace t ON t oid   c reltablespace      LEFT JOIN pg description As d            ON  d objoid   c oid AND d objsubid   0       WHERE c relkind IN  r    v   AND d description  gt          ORDER BY n nspname  c relname     Column Comments      SELECT n nspname AS schema name        pg get userbyid c relowner  AS table owner        c relname AS table name        a attname AS column name        d description AS column description     FROM pg class AS c     INNER JOIN pg attribute As a ON c oid   a attrelid     INNER JOIN pg namespace n ON n oid   c relnamespace     LEFT JOIN pg tablespace t ON t oid   c reltablespace     LEFT JOIN pg description As d       ON  d objoid   c oid AND d objsubid   a attnum      WHERE c relkind IN  r    v        AND a attname NOT               IN   cmax    oid    cmin    deletexid    ctid    tableoid   xmax    xmin    insertxid       ORDER BY n nspname  c relname  a attname

User · Answer

I had to select from the information schema to get details of my tables and columns  in case it helps anyone   SELECT   FROM information schema tables WHERE table schema    myschema     SELECT   FROM information schema columns WHERE table schema    myschema  AND table name    mytable

User · Answer

You can simply use the command below to describe a table     desc table-name   or  desc schema-name table-name

User · Answer

Shortcut   d for show all tables   d tablename to describe table     for more shortcuts for redshift

User · Answer

You can use - desc   to see the view table definition in Redshift  I have been using Workbench J as a SQL client for Redshift and it gives the definition in the Messages tab adjacent to Result tab

User · Answer

All the information can be found in a PG TABLE DEF table  documentation   Listing all tables in a public schema  default  - show tables equivalent    SELECT DISTINCT tablename FROM pg table def WHERE schemaname    public  ORDER BY tablename    Description of all the columns from a table called table name - describe table equivalent    SELECT   FROM pg table def WHERE tablename    table name  AND schemaname    public

User · Answer

Tomasz Tybulewicz answer is good way to go   SELECT   FROM pg table def WHERE tablename    YOUR TABLE NAME  AND schemaname    YOUR SCHEMA NAME     If schema name is not defined in search path   that query will show empty result  Please first check search path by below code   SHOW SEARCH PATH   If schema name is not defined in search path   you can reset search path   SET SEARCH PATH to   user   public  YOUR SCEHMA NAME

[amazon-web-services] Show tables, describe tables equivalent in redshift

Examples related to amazon-web-services

Examples related to amazon-redshift