Search found 27 matches

by clv100
Fri Mar 15, 2013 6:45 pm
Forum: Vertica Management Console
Topic: Connecting to DB from MC cannot see tables in DB
Replies: 2
Views: 16315

Connecting to DB from MC cannot see tables in DB

I am VERY new at this. I am logged into the Management Console node. I enter vsql and enter the connection string to the database. It confirms "CONNECT". However, if I try to view the tables in the database, I only see the tables from the Management Console node. Can you tell me what I am doing wron...
by clv100
Thu Oct 18, 2012 4:25 pm
Forum: Python
Topic: Python Class to return column names of a table
Replies: 5
Views: 25122

Re: Python Class to return column names of a table

Thank you!! I understand!!
by clv100
Thu Oct 18, 2012 3:32 pm
Forum: Python
Topic: Python Class to return column names of a table
Replies: 5
Views: 25122

Re: Python Class to return column names of a table

Thank you so much! That worked!! The odd thing is, the first block of code (where I am retrieving the rows from a table, works fine without the single quote within the double quote)? The only difference in the second block of code is that I am retrieving the columns from the table so I am now in the...
by clv100
Wed Oct 17, 2012 8:36 pm
Forum: Python
Topic: Python Class to return column names of a table
Replies: 5
Views: 25122

Python Class to return column names of a table

First of all, we are VERY new to Vertica and Python. We have been running Vertica since August for a very limited process and we are now trying to expand the processing. I have created a class to return the rows in a table : ######################################################### import pyodbc cla...
by clv100
Tue Oct 16, 2012 7:01 pm
Forum: Vertica SQL
Topic: SQL for select the column name from a table
Replies: 2
Views: 8473

Re: SQL for select the column name from a table

Thank you so much for your quick response!! It worked too!! Thanks again!
by clv100
Tue Oct 16, 2012 6:11 pm
Forum: Vertica SQL
Topic: SQL for select the column name from a table
Replies: 2
Views: 8473

SQL for select the column name from a table

I am new to Vertica and am trying to create a sql query in a python script that will return the column_names of a table in a cursor. I am coming from a relational db (Informix) where that is very easy to do. Does anyone know how I can do this in Vertica? Thanks for your help!

Go to advanced search