The Vertica Database Forums

Code: Select all

dbadmin=> \dn jim;
     List of schemas
 Name |  Owner  | Comment 
------+---------+---------
 jim  | dbadmin | 
(1 row)

Code: Select all

dbadmin=> \d jim.*;
                                List of Fields by Tables
 Schema | Table | Column | Type | Size | Default | Not Null | Primary Key | Foreign Key 
--------+-------+--------+------+------+---------+----------+-------------+-------------
 jim    | tab1  | col1   | int  |    8 |         | f        | f           | 
 jim    | tab2  | col1   | int  |    8 |         | f        | f           | 
(2 rows)

Code: Select all

dbadmin=> \d public.table_row_counts 
                                            List of Fields by Tables
 Schema |      Table       |    Column    |     Type     | Size | Default | Not Null | Primary Key | Foreign Key 
--------+------------------+--------------+--------------+------+---------+----------+-------------+-------------
 public | table_row_counts | table_name   | varchar(100) |  100 |         | f        | f           | 
 public | table_row_counts | row_count    | int          |    8 |         | f        | f           | 
 public | table_row_counts | at_timestamp | timestamp    |    8 |         | f        | f           | 
(3 rows)

Code: Select all

[dbadmin@vertica01 ~]$ vsql -Atc "select 'select ''' || table_name || ''' table_name, count(*) row_count, now() at_timestamp from ' || table_schema || '.' || table_name || ';' from tables where table_schema = 'jim';" | vsql -At | vsql -c "copy public.table_row_counts from stdin direct;"

[dbadmin@vertica01 ~]$ vsql -c "select * from public.table_row_counts;"
 table_name | row_count |        at_timestamp        
------------+-----------+----------------------------
 tab2       |         3 | 2014-02-19 08:44:25.887141
 tab1       |         1 | 2014-02-19 08:44:25.887141
(2 rows)

Code: Select all

 vsql -Atc "select 'select ''' || table_name || ''' table_name, count(*) row_count, now() at_timestamp from ' || table_schema || '.' || table_name  from tables" | vsql -At |  vsql -c "copy public.table_row_counts from stdin direct;" 
vsql: FATAL 2983:  Database "vsql" does not exist
ERROR 4856:  Syntax error at or near "select" at character 76
LINE 2: select MEASURES_CORE_AMOUNTTYPE table_name, count(*) row_cou...