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

Can someone explain what’s a culture day and how do you take it?

like

Kith x nonnative UB mid w/ Kith x adidas cobras sideline jacket

Post Photo
like

Hello guys
Please help me get 11 likes.

likeupliftinghelpfulsmartfunny

Title company just gave me a commitment with 72 B2 exceptions and the first one (after standard) is an unrecorded lease from 1862. Send help.

likefunny

Curious what firms are doing to keep people socializing during COVID. I miss my coworkers but I'm sick of zoom calls.

like

Anyone here familiar with the medical records field reviewer positions at Change Healthcare? Looking to get a little more info on schedule, workload, and pay specifically. TIA!

like

Anyone know of a good tutor for CFP exam? Thx.

like

Hi Folks,

I’ve a question, can we take parental leave in
TSYS during probation or 1 week cl/el leave ?

Thanks in advance TSYS

What's your favorite thing about being a physician? With all the stress and heavy stuff we deal with, it's nice to reflect on the positives sometimes...

like

If an otherwise good interview the interviewer says: “I think you have great experience that will help you wherever you go”. Should I be reading into this?

like

Ok Perry Masonary, go back to Bedrock.

Post Photo
likefunny

Does the sf office have lockers?

smart

What will be the hike % for M leval in EAS IPM ?

like

I can do the math on SWR’s, but always happy to have the input of this forum, be it positive, constructive, or a really unique perspective. I’ve been lurking on a FIRE journey for a while, and here is where I am:
2.3M in retirement assets (30% have been taxed)
8k a month in expected expenses…continued in comments

like

I finally decided to invest in cryptocurrency but not sure how and where to start. I am looking to invest from a long term perspective (5-10 years).

Are there any low risk steady increase options or is the whole crypto currency a high risk game?

like

Any clue when the scatter plots are out?

like

How is CGI work culture and Banglore office?

Any job opportunity for a business analyst in bangalore? Having 8 YOE, data analytics space, power BI, qlik experience, serving notice period.

Any M or SM here

like

This is second time I got offer from CGI but now I have again a better opportunity. So if this time I reject will there be any problem for me in future?

Additional Posts in Data & Analytics Consultants

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

I am finishing up a project and I’m trying to document what I’ve done for my resume. What are some good metrics for someone who mainly created user stories, created dashboards, interacted with the client and developed statistical models? One of my dashboards got deployed to production but it’s to early to see the impact. My other dashboards are almost done but I’m moving on to something else.

like

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

like

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

like

I have a undergrad finance degree and 5 years of big 3 credit rating agency work experience, what will help me more to get into a SFA role or product role at a tech company, a T15 MBA or a Georgia tech masters in analytics degree?

like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

Coming from ACN, senior analyst, 3yrs total experience so far & wanting to get into the data analytics/BI work. Currently have had experience working with SQL developer, OBIEE/OBIA, Teradata in ERP and Healthcare projects. I also have my AWS Cloud Practitioner Cert, hoping to eventually get the Data Analytics Cert later. What are my chances of finding a role with another company that'll let me work in BI/data analytics and build up my skill at the same time? Been thinking of leaving ACN.

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

What are the data science track levels at Capital One?

like
like

Looking for technical data analyst in Austin, tx (also have remote available) to join a series E startup. Need strong python & sql experience. A lot of data munging and cross-functional work. Love to chat if this makes sense. Cheers!

helpful

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

Got Amazon career essentials (ACE) assessment to complete for Business Analyst role
To anyone who has experience with it- What kind of work simulation questions should I be expecting?
Is there a way I can prepare for it or any resources one must know of?

like

Best way to explain to new firms that you are leaving your current firm because of the toxic culture and frankly, a President who talk down to people every chance he gets?

like

For those with experience with Apache Superset, please tell me more. Why do you prefer it, which environment does it work best in, pros/cons, and why should I choose it over Tableau/PowerBI?

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

Scan your QR code to download
Fishbowl app on your mobile

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