Trying to just select column names and type in postgres but it's coming up blank. Query is:
Select column_name,data_type
FROM information_schema.columns
WHERE table_name='myschema.mytablename'

This is coming up blank but there is data and column names. What am I doing wrong?

like
Posting as :
works at
You are currently posting as works at

Let me stackoverflow that for you

likesmartfunny

Pretty new to SQL, looked through stack overflow but I keep getting the same queries which keep coming up blank for me

Table name column does not have schema. Your where clause should be:

Table_name = ‘mytablename’

Schema is in a separate column

like

“And” instead of another “where”

Add table name to your select and remove the filter. Add the where statement back as a LIKE condition with wildcards to see if the filter is off. Not super familiar with postgres but could be a case issue or something

like

Conceptually your approach is right, you should have the following where conditions:

Where table_name = ‘mytablename’ and table_schema = ‘myschemaname’

like

Thank you so much! This is all new to me and I'm sure this is a basic query for you all! Appreciate your assistance!

like

try “select top 10 * “ in the first row - that will tell you if the error is in the first row

Related Posts

Passed first phone screen (GCA) and have an upcoming call with hiring manager. Should I expect a formal format (GCA, RRK, etc) or are HM rounds typically unstructured/can be anything? Product strategy role if relevant

like

What benefits does JP Morgan offers for AVP role? In specific to GFCC groups..

like

Does The Consortium need to have my official score report on the day of the deadline? I assumed it would be like other schools where you can just self-report first and they'll ask for the official later

like

How is Work Life balance & culture at Optum (Gurgaon). I understand it is dependent on manager/team but if anyone can share their experience in general.

like

I want to find out what are CDM, CFPP being paid in California,LA area.

like

Do interns in FDD usually work overtime in the summer?

likefunny

What kind of testing projects are there in TCS?Are most of them manual ?

like

Any one know how ip lit is at MoFo Los Angeles?

likesmart

Any referrals for Front end angular devlopment 8years exp?

like

Hi! I want to become a Credit Analyst. Can someone refer me to Pacific Premier Bank or Deutsche Bank? Thanks a ton

Tech Mahindra Hey guys, I attempted Hackathon by tech Mahindra (for jr java developer 1-3 yr exp). After 3 days I received a call from hr confirming that I have been shortlisted and took hr round on that call. Later I received a document verification mail asking for all essential docs which are required for joining, but didn't received any offer letter yet. When I cross checked mail address with my friend in tech Mahindra, he confirmed that such hr exists with same e-mail id. Is it normal in tech Mahindra?

like

What is the PwC equivalent for a Kearney Associate and/or ACN consultant? 4-5 YOE, both in industry and consulting

Thinking of buying a builder property which is due to be delivered in next 2 years. Any risks I should be aware of?

like

I’m a first time founder of an early stage health tech startup focused on helping people discover doctors and wellness solutions. Looking to network and find a co-founder!
I’m in pre-launch of a q&a product feature for people to ask questions and healthcare professionals to answer these questions.
If you have experience taking these products to market, what are effective outreach strategies?

like
like

SuccessFactors LMS Roadmap!

Looks Interesting!!

#SAP #SuccessFactors #HXM #LMS #Learning

Post Photo

Hello! Does anyone know of any open positions in your company within the Total Rewards realm? Preferably Benefits Specialist/Analyst roles? My preference is remote but I’m open to hybrid options in Atlanta area as well!

like

It's not like Im jealous of iphone users with their stupid little cute and interesting emojis that my android phone can't do or anything 🧐

funnylikeuplifting

Any single lady out here for a conversation and we see where it leads to 😊 we can be friends

like

Additional Posts in Data & Analytics Consultants

What are some large open source structured datasets for our experimenting pleasure?

like

Lunch discussion at the office, curious to hear your thoughts: Does one need to learn data science first to be a good data engineer / architect? Why / why not?

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

Does anyone work for a company that is paying for them to get an MS in Data Science or Business Analytics? If so, where?

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

I need a new laptop. Not sure what to look for other than a SSD, 16 GB Ram, and an i7 processor. Fine with Apple or Windows. What else should I look for if I want to do a lot of my own kaggle and

Anybody looking for data strategy or technical PM for analytics projects?

likehelpful

What’s the coolest data solution you have delivered? The industry is getting a little predictable and some inspiration is always welcome.

like

Analytics 💵 transparency thread!


Format:
Title level (standardized title/job level)
Economic area (Bay Area, Midwest, etc)
Salary + bonus + liquid equity
Anything else you think would help

likesmarthelpful

what do you talk about in your 1:1s?

I got lucky and now have leadership that seems to care about my career growth, but I'm 1. a little overwhelmed taking over a new role from someone who went on parental leave earlier than expected and 2. not used to thinking outside my day to day job, happy to keep my head down and just produce good work.

most of what I bring up in these meetings are logistical or prioritization concerns but I feel like my manager is expecting a lot more from me.

like

Looking for strategy and analytics consulting role in the big 4 . Any help would be welcome thanks

like

When you thought you failed the tech screen so did zero prep for later rounds but then get a message and now have less than a week to get your acorns together

Post Photo
likefunny

Interviewing for a deals analytics role at EY- the interview day will include time with a partner, a senior manager, two managers and a 3 hour case study. What should I expect?

DM for referral at a boutique consulting firm:

- fully remote
- good WLB
- hiring all levels with above average pay
- 3+ YOE with experience in analytics/BI in financial services background preferred

likehelpful

Is it possible to switch from data analytics to strategy? If so, what kind of strategy? I’m still thinking about career possibility. Thank you

like

What’s the best company for machine learning projects?

like

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

Looking to move from consulting to chill DS/analytics role. Don’t care too much about TC ($150k is fine), but WLB is paramount for me. Anyone have any thoughts as to where I can get this?

like

I’m 3 months into a my first job as an entry level Business analyst with high data focus at a big investment bank but contracted by a consulting firm. I don’t come from a tech/finance background so I was promised training. I don’t feel like I’m don’t feel like I’m learning anything though and everything is so slow placed I feel more like an intern given small tasks. my manager is also new to tech so I don’t know who to look for as a mentor… any advice pls ?

like

Can anyone please provide the best recommended training link to study for the AWS Cloud Solutions Architect Associate Certification? I want to study for it end-to-end and complete it within a few weeks!

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal